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" <DebC(a)discussions.microsoft.com> wrote in message news:12C50B6EA0FA4CC088BD17A8DFAC1BB0(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 statment Next: cannot open Excel (.xls) attachments in Outlook 