Cell B1 is driven by a list in Cell A1.
If A1 has a word in it, B1 displays the appropriate number, if A1 is blank, B1 is as well.
Cell B1's formula is as follows:
=IF(ISBLANK(A1),"",VLOOKUP(AK7,raceTable,2,0))
------so far so good------
Cell [BC1 [/B]is driven by cell B1. The purpose of C1 is to take the number in B1 and divide it by 5. If B1 is blank, then C1 should be blank as well.
C1's current formula is:
=IF(ISBLANK(B1),"",(B1/5))
This works fine for dividing, but if B1 is blank, then C1 displays #Value instead of blank . I want it to display blank.
------on a further note------
If I put in the following formula in C1:
=IF(ISBLANK(B1),"",B1)
Then I get a proper blank, so it seems to me that the division is what's causing the display error. I am curios as to why it occurs only when the formula is divided.
An example file is attached.
I appreciate any help.
Bookmarks