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

"Larry" wrote:

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!

That worked - thanks!
How can I hide or omit the zero if the criteria was not met.

"Miguel Zapico" wrote:

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

"Larry" wrote:

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!

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)

"Larry" wrote:

That worked - thanks!
How can I hide or omit the zero if the criteria was not met.

"Miguel Zapico" wrote:

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

"Larry" wrote:

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!