Prev: If statment
Next: cannot open Excel (.xls) attachments in Outlook
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: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 statment
Next: cannot open Excel (.xls) attachments in Outlook