View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DebC DebC is offline
external usenet poster
 
Posts: 39
Default combine formulas into 1

In the examples below, is it possible to combine the 2 formulas into one?
I need to simplify my spreadsheet if possible.

IF(M3=H1,IF(MAX(H3,H7,H11,H15,H19,H23)=MAX(H5,H9 ,H13,H17,H21,H25),1,2

IF(M4=H1,IF(MAX(h3,h7,h11,h15,h19,h23)<=MAX(h5,h9 ,h13,h17,h21,h25),2,3

Thanks very much for any help.