Excel Formula

  Abel 11:51 15 Aug 08
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 08

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 08

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 08

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.

How about;

=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 08

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 08

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

  Abel 13:39 15 Aug 08

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

New iOS 11 release date rumours UK | new features coming to Siri, FaceTime, Messages and Video