Formula to display nothing if false

[ddub25]

Hello

I have this simple formula in a table: =SUM(A1/B1)

I want it to display nothing when A1 and B1 are empty - at present it returns:
#DIV/0!

Can anyone help? Thanks.

Dan

[zbor]

First, you don't need SUM function.

You can try this: =IF(B1;A1/B1;"")

(replace ; with , if you get error)

[DonkeyOte]

Sometimes to safer to check coerced value of divisor (ie IF("apple" would return TRUE)

=IF(N(B1),A1/B1,"")

however if A1 is non-numeric you will also get a #VALUE! error - if that is a concern also then best to use an all encompassing error check - ie double evaluate.

[ddub25]

Thanks for both replies. The 1st solved the problem. I havent tried the 2nd, but thanks anyway. Thanks.

Dan

[ddub25]

just realised that I would also like the formula to ask if AF1923 is empty and if so, also return "--"

Here is the current formula:
=IF(AB1923,AI1923/AB1923,"--")

Can anyone help? Thanks.

Dan

[zbor]

And it doesn't working?

DQ, I agree. However, maybe it's not bad to get error when divisor is text (as for a number). Depending on users wish...

[ddub25]

It works fine, I just want to change the IF statement slightly. Ignore my post above I got confused.

My original formula is this:
=SUM(AI1914/AB1914)

I want the formula to return nothing if AF1914 is empty, if it is not empty then it can continue to do the sum. Any ideas on how to express this? Sorry for my confusion.

Dan

[zbor]

=if(af1914="","",if(ab1914,ai1914/ab1914,"--"))

[ddub25]

Thanks a lot. That works perfectly.

Dan