Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
If then statements | Excel Worksheet Functions | |||
IF Statements | Excel Worksheet Functions | |||
Add two IF statements together | Excel Worksheet Functions |