Excel Formula

Posted By: VB Man | Jan 10th @ 6:22 PM
page 1 of 1
Comments: 4 | Views: 785
#Jan 10th @ 6:22 PM
VB Man
VB Man
Year of the Linux MCE.
I'm looking for a formula to do this...

Say I have 5 cells. If at least 3 of those cells have '100' in them, another cell should display a set value such as "WooHoo" or whatever. Here's the catch: if 4 of the cells have at least '100' something else should be shown.

Is there a formula to do something like this?
#Jan 10th @ 6:38 PM
RoyalSchrubber
RoyalSchrubber
One. How many time travellers does it take to change a lightbulb?
If that VB in your name is abbreviation for 'Visual Basic' then I think you're capable of doing it yourself - as you see, like Word, Excel too is scriptable with dialect of Basic called Visual Basic for Applications (VBA). 

I probably could manage to write it, but I'm too lazy and I don't even have Office installed on this computer. (MSDNAA doesn't provide me with it so I'm on openoffice)
#Jan 10th @ 6:41 PM
VB Man
VB Man
Year of the Linux MCE.
The point was to make it without using VBS for Office.... hence 'Excel Formula'.

Anyways, countif seems to have done the job I needed it to. 
#Jan 10th @ 7:03 PM
RicardoClerigo
RicardoClerigo
Hi!

What you ask, if I understood it correctly, is very simple.

I made an example (download here in sendspace).

If you have any questions feel free to ask!

Hope this helps,
Ricardo Clérigo
#Jan 11th @ 6:07 PM
JoshRoss
JoshRoss
A righteous infliction of retribution manifested by an appropriate agent.
=IF(COUNTIF(A1:A5,"100")=3,"WhooHoo","HooWoo")
page 1 of 1
Comments: 4 | Views: 785
Microsoft Communities