Multiple IF Statements

    I'm trying to determine a load, but it seems that the cell needs multiple if statements and I cant seem to get it to work quite right.


    if sec = 1, if sec*lab+sec*lec>1.5*sec then 1.5*sec, else sec*lab+sec*lec
    but if sec=2, if sec*lab+sec*lec>3*sec then 3*sec, else sec*lab+sec*lec
    but if sec=3, if sec*lab+sec*lec>4.5*sec then 4.5*sec, else sec*lab+sec*lec


    I need to do this on an excel side, not VBA but when I plug it in, I either get a True/false returned or #VALUE

    I don't know if I need to use a if/or or if/and?? I would super appreciate anyone willing to take the time to help me on this one! Thanks :)

    Re: Multiple IF Statements


    As you haven't explained what 'sec', 'lab' & 'lec' are, I'll assume named ranges.


    You might find it easier to use the Choose() function for the first selection (sec=1, 2 or3), it makes it a lot clearer when viewing the formula.



    =CHOOSE(sec, IF((sec *lab)+(sec*lab)>sec*1.5, sec*1.5, sec*2), 2, 3)



    Because of my assumption, that only includes the calculation for sec = 1. You should be able to replace the last 2 parameters (2 & 3) with the relevant calculation, and why not use (sec *lab) * 2 rather than (sec *lab)+(sec*lab)?


    OK, I've edited this 3 times and it refuses to add the new lines - hopefully double spacing them might work but if this is still all running together I have tried to edit it.

    Re: Multiple IF Statements


    Try this


    =IF(sec=1,IF(sec*lab+sec*lec>1.5*sec,1.5*sec,sec*lab+sec*lec),IF(sec=2,IF(sec*lab+sec*lec>3*sec,3*sec,sec*lab+sec*lec),IF(sec=3,IF(sec*lab+sec*lec>4.5*sec,4.5*sec,sec*lab+sec*lec),"")))


    or, using Choose


    =IFERROR(CHOOSE(sec, IF(sec *lab+sec*lec>sec*1.5, sec*1.5, sec *lab+sec*lec), IF(sec *lab+sec*lec>sec*3, sec*3, sec *lab+sec*lec),IF(sec *lab+sec*lec>sec*4.5, sec*4.5, sec *lab+sec*lec)),"")


    Both of these will return an empty cell value if sec is anything other than 1, 2 or 3

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: Multiple IF Statements


    As far as I can see, this can be abbreviated to


    =MIN((SEC*LAB)+(SEC*LEC),SEC*(1.5*SEC))

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login