Inconsistant formula

Why would I get an inconsistent formula on

=IF(ISERROR((D18+D19)/D20),"",(D18+D19)/D20-1)
Matt PinkstonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Are you referring to the Error marking feature in Excel that gives a little green triangle in top left corner of the cell.

If you are getting an "Inconsistent Formula" error showing, that means that the formula in the cell is different to those around it.

For example, if you have a row of totals:
SUM(C1:C15)
SUM(D1:D15)
SUM(E1:E12)
SUM(F1:F15)

The formula referring to column E is likely to get one of two error markings; either inconsistent or refers to cells with data adjacent but not included.

Thanks
Rob H
0
 
NBVCCommented:
Why do you have a minus 1 at the end?

Should the -1 be part of the denominator?  If so, should it be:  
=IF(ISERROR((D18+D19)/D20),"",(D18+D19)/(D20-1))

Not sure what you mean by "inconsistent"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.