combine formulas into 1

D

DebC

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.
 
L

Luke M

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top