Another way using COUNTIF()

=IF(COUNTIF(H90:L90,"1"),true statement,falsestatement)

=IF(COUNTIF(H90:L90,"1"),G90*M90*P90,G90*7850*(N9 0/1000*O90/1000*Q90)

If this post helps click Yes
---------------
Jacob Skaria


"Ray" wrote:

I would like to simplify (reduce) the number of IF statements in this
formula: -
=IF(H901,G90*M90*P90,IF(I901,G90*M90*P90,IF(J90 1,G90*M90*P90,IF(K901,G90*M90*P90,IF(L901,G90*M9 0*P90,(G90*7850*(N90/1000*O90/1000*Q90)))))))

Without a Macro, as there is already macros operating elsewhere in the
spreadsheet. I was thinking of something like:

=IF(H90:L901,G90*M90*P90,,(G90*7850*(N90/1000*O90/1000*Q90)), but this
returns a #VALUE error.

Can anyone help?