How to ad a IF in a existing formula

[feejo]

I have that formula =Sum(BC22:$BC4000)
But I want to add that formula how apparently remove the 0.
=IF(SUM(A1:B1)<>0,SUM(A1:B1),NA())

[pinmaster]

Hi,

How about:

=IF(SUM(A1:B1)=0,"",SUM(A1:B1))


HTH
Jean-Guy

[pinmaster]

Hi,

Sorry, looking back at your post and now I'm not sure what you meant. You want to add which formula to which?

here are some simple samples that might help you!

basic IF function.
=IF(condition,true,false)

basic IF function used if the condition returns a TRUE statement
=IF(condition,IF(condition,true,false),false)

another example
=IF(condition,IF(condition,IF(condition,true,false),false),false)

basically you can use an IF function as the condition, true or false statement in another IF function, if used as a condition make sure it returns either a TRUE or FALSE statement so that the formula will work properly!

Hope this helps!
Jean-Guy

[nattasiray]

Hello feejo

Using Custom Format Number rather than using the danger formula as below

Please Login or Register  to view this content.

Because, The dangerous formula give the result is text. If you need to use the result to calculation, but the dangerous formula give the result is text. It will return #VALUE!

How to use The custom Format Number.

Choose cell
Right Click choose format cells...
Click Number Tab
At the categories list box choose custom.
At the Type text box Type #,##0.00 ;[Red] -#,##0.00 ;;
Click OK