If Statements:

L

Larry

When I use an if statement, I can get the answer I want but I can't add it to
another if statement. Example: IF(B4="FP","10"," ") 10 shows up where it is
supposed to in M4. But if I try to sum this total to another SUM(M4+M5) it
get a #VALUE!
 
D

Dave O

Please confirm that your IF statement cell is formatted as numeric, as
opposed to text. If it is text, format it as a number, then with your
cell pointer on that cell, press F2 (to edit the formula) and Enter.
 
M

Miguel Zapico

That may be because the value is identified as text. Try without the quotes:
IF(B4="FP",10,"")
 
M

Miguel Zapico

For that you can use conditional formating under the format menu. If the
cell value is 0, use white ink (or the same that you have in the background)
 
Top