If then statements
One way:
=0.25*(COUNT(A1:C1)=3)
In article ,
Emily wrote:
Hi, I know this is probably a really easy question... but I'm not very good
in excel yet. Here is what I'm trying to do:
I have three cells that I will put numbers in. If all three of these cells
have numbers in them, I want the "total cell" to say .25. If they don't...
then I want it to say 0.
How do I do this?
Thanks for your help!
|