An easy one

[elvezrulz]

I love this forum because I always get an answer quickly and it always helps! Here's an easy one. I need a formula that will give me a negative number in column c when column a is a positive and column b is N/A. Column a represents orders, column b represents inventory and column c is supposed to be inventory after orders are filled, and when there is no inventory I need it to reflect a negative number. The formula in the example is what I have in there now. Sorry for my ignorance!

A.....................B.........................C
Orders.........Inventory.............Net Inventory
100................N/A.....................=A3-B3

 

[VoG]

Maybe

=IF(ISNA(B2),"",B2-A2)

 

[Misca]

Try: =IF(ISERROR(B2),0,B2)-A2

 

[Jonmo1]

Will only column B have the N/A?
And is the N/A just a text string, or is it an error result of a formula?

If only column B has the N/A, and it's jsut a text string, not a formula error,
then try

=IF(ISNUMBER(B3),B3-A3,-A3)

something tells me you actually want B3-A3 (Inventory-Orders)
Rather than Orders-Inventory..

 

[elvezrulz]

Awesome, thanks!