If then statements
 

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!

If then statements
 

With your 3 number in A1 to C1 try in another cell

=IF(COUNTIF(A1:C1,"0")=3,SUM(A1:C1),"")

Mike

"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!

If then statements
 

If any of A1, A2, or A3 are blank the result is 0 otherwise result is .25
Try this:

=IF(OR(A1="",A2="",A3=""),0,0.25)

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!