From: DebC on 28 May 2010 15:46 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. From: Luke M on 28 May 2010 16:00 As they have different tests/outputs, how do you want them combined? Also, there are two IF functions, but only one set of outputs. Perhaps these are an AND condition? A simple way (with a lot of assumptions made): =IF(AND(M3>=H1,MAX(H3,H7,H11,H15,H19,H23)>=MAX(H5,H9,H13,H17,H21,H25)),1,2)+ IF(AND(M4>=H1,MAX(H3,H7,H11,H15,H19,H23)<=MAX(H5,H9,H13,H17,H21,H25)),2,3) -- Best Regards, Luke M "DebC" wrote in message news:12C50B6E-A0FA-4CC0-88BD-17A8DFAC1BB0(a)microsoft.com...> 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.  |  Pages: 1 Prev: If statmentNext: cannot open Excel (.xls) attachments in Outlook