# Excel Formula

Abel 11:51 15 Aug 2008
Locked

The following formula
=IF(ISBLANK(C31),"",D30+C31) is in cell D31.
Also, cell E31 contains the following formula
=IF(D31="","",ROUNDUP(5009/52,2)+ROUNDUP(1039/52,2))*23
Despite the =IF(D31="","",etc.,), I've tried ISBLANK too, in cell E31, a value of 0.00 is returned. If I’ve expressed myself adequately, could someone please explain why cell E31 isn’t blank?

Abel

Simsy 13:09 15 Aug 2008

You've possibly got the brackets in the wring place, depending on what the formula is trying to do, or the logic is unsound...

Are you getting a "VALUE" error?

I think whats happening is that you are trying to multiply "", (ie an empty string, which is not the same as nothing), by a number.

If you make the formula in D31;
=IF(ISBLANK(C31),0,D30+C31)
does it work?

Regards,

Simsy

Simsy 13:11 15 Aug 2008

what you've written. Though what I've said still holds, you're getting a value of 0 which is not what I'd expect.

In case it makes a difference, what version of Excel is it?

Regards,

Simsy

Simsy 13:22 15 Aug 2008

Because D31 contains a formula, (i.e. D31 doesn't contain ""), then the formula in E31 that says;

=IF(D31="", will never evaluate to true.

=IF(Value(D31)=0,"",.... in E31

combined with the changes to 0 instead of "" in the D31 cell.

Regards,

Simsy

Picklefactory 13:23 15 Aug 2008

Problem is that if D31 = "" then formula is trying to do "" x 23 as the *23 is outside the IF statement.

Picklefactory 13:24 15 Aug 2008

=IF(D31="","",(ROUNDUP(5009/52,2)+ROUNDUP(1039/52,2))*23)

Abel 13:39 15 Aug 2008

Thanks Picklefactory, you've solved the problem for me. Thanks for your contribution too, Simsy,

Abel

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

Best Keyboards for Designers & Artists

What to ask Siri on the HomePod

Meilleurs VPN (2018)