Inconsitent Formula Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
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.
 
Back
Top