View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RaY RaY is offline
external usenet poster
 
Posts: 164
Default Simplifying IF Statement

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?