If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
combine formulas into 1
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,H 9,H13,H17,H21,H25)),2,3) -- Best Regards, Luke M "DebC" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|