software

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

quot;Larryquot; wrote:

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

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

quot;Miguel Zapicoquot; wrote:

gt; That may be because the value is identified as text. Try without the quotes:
gt; IF(B4=quot;FPquot;,10,quot;quot;)
gt;
gt; quot;Larryquot; wrote:
gt;
gt; gt; When I use an if statement, I can get the answer I want but I can't add it to
gt; gt; another if statement. Example: IF(B4=quot;FPquot;,quot;10quot;,quot; quot;) 10 shows up where it is
gt; gt; supposed to in M4. But if I try to sum this total to another SUM(M4 M5) it
gt; gt; 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)

quot;Larryquot; wrote:

gt; That worked - thanks!
gt; How can I hide or omit the zero if the criteria was not met.
gt;
gt; quot;Miguel Zapicoquot; wrote:
gt;
gt; gt; That may be because the value is identified as text. Try without the quotes:
gt; gt; IF(B4=quot;FPquot;,10,quot;quot;)
gt; gt;
gt; gt; quot;Larryquot; wrote:
gt; gt;
gt; gt; gt; When I use an if statement, I can get the answer I want but I can't add it to
gt; gt; gt; another if statement. Example: IF(B4=quot;FPquot;,quot;10quot;,quot; quot;) 10 shows up where it is
gt; gt; gt; supposed to in M4. But if I try to sum this total to another SUM(M4 M5) it
gt; gt; gt; get a #VALUE!