Using blank cells in mathematical operations

**Sean Anderson** · 01-01-2008, 05:03 PM

I got myself in a bind. Attached is an example of my problem.

I learned that Excel will allow the use of blank cells in mathematical operations. However, it won't allow a cell that appears blank but has a formula in it to also be used in mathematical operations. See cell B3 and you'll see what I mean. Is there a way to make it work? Many thanks.

**VBA Noob** · 01-01-2008, 05:13 PM

You could try tools > options > view tab > untick zero values and then you won't need the if statements in B1 & B2 or try

=IF(ISERROR(B2-B1),0,24*(B2-B1))

or

=IF(COUNT(B1:B2)=0,0,B2-B1)

formatted as C1

Please Login or Register  to view this content.

VBA Noob

**corinereyes** · 01-01-2008, 05:26 PM

or:

B1: =IF(N(A1)=0,N(0),A1)
B2: =IF(N(A2)=0,N(0),A2)

then try VBA Noob's suggestion ->

You could try tools > options > view tab > untick zero values and then you won't need the if statements in B1 & B2

**Sean Anderson** · 01-05-2008, 02:12 AM

Thanks, that did the trick. I will use

=24*(N(B2)-N(B1))

in cell B3.

Using blank cells in mathematical operations

LinkBack

Thread Tools

Rate This Thread

Display

Using blank cells in mathematical operations

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions