Formula to calculate a formula if another formula produces a certain value?

[brickZ52]

Hello all,

I am trying to create a formula in which for example, if C5<=0, show the value "N/A". Ff C5>0, then calculate the formula of C5/B5.

Can anyone help?

THanks!
Greg

 

[Joe4]

Welcome to the Board!

Try:

=IF(C5 <= 0,"N/A",C5/B5)

 

[brickZ52]

Welcome to the Board!

Try:

=IF(C5 < 0,"N/A",C5/B5)

I got it to work using this:

=IF(H4<>0,H4/F4,IF(H4=0,"N/A"))

 

[Joe4]

I got it to work using this:

=IF(H4<>0,H4/F4,IF(H4=0,"N/A"))

Well, the conditions and cell references are different than your original question, as you had stated that you wanted it to return "N/A" for values less than or equal to zero, and your new equation only returns "N/A" if it is exactly equal to 0.

If you new formula, accomplishes what you are really after, then as long as you only have numeric values in H4, you don't need a nested IF. You can simplify your formula to:

[COLOR=#333333]=IF(H4<>0,H4/F4,"N/A")[/COLOR]

because if you only have numeric values in H4, then if you check to see if the value is NOT zero, the only other option is that it is zero (so you don't really need to check for that value, you can just say return "N/A" otherwise).

 

[brickZ52]

Well, the conditions and cell references are different than your original question, as you had stated that you wanted it to return "N/A" for values less than or equal to zero, and your new equation only returns "N/A" if it is exactly equal to 0.

If you new formula, accomplishes what you are really after, then as long as you only have numeric values in H4, you don't need a nested IF. You can simplify your formula to:

[COLOR=#333333]=IF(H4<>0,H4/F4,"N/A")[/COLOR]

because if you only have numeric values in H4, then if you check to see if the value is NOT zero, the only other option is that it is zero (so you don't really need to check for that value, you can just say return "N/A" otherwise).

I originally chose the cells C5 and B5 and then when I figured it out, just copied/pasted the formula from a different set of cells. However, I do see your point in that 2 conditions are not needed and your formula gets the same job done in a simpler manner.

Appreciate the help guys!

Greg