Inconsitent Formula Error

[Rich]

=IF(ISBLANK(B7),"",INT((B7/$B$9)*A17))

I get the little triangle at the top left corner of the cell which contains
the formula above, and it says "Inconsistent Formula Error".

If B7 is empty, I want to leave the receiving cell empty, Else write the
respective number. If I just have =INT((B7/$B$9)*A17) in the receiving
cell, that places a 0 (zero) in the respective cell. I need that cell to
remain empty if there is no number to calculate in B7. What is the correct
formula to do this?

Thanks,
Rich

 

[Dave Peterson]

Inconsistent formulas don't mean that your formulas are wrong--only that they're
not similar to the formulas in surrounding cells.

An easy example:
In B1: =a1+5
B2: =a2+5
B3: =a3+5
B4: =a4+15
B5: =a5+5

B4 will be marked with an inconsistent formula--It just looks like it doesn't
belong with the others.

You may want to check the surrounding formulas to see if you have an
unintentional difference in formulas.