If Statement Help for Multiple Variables.

  • I have the following if statement. =IF(E58=0,(D58*(1+$C$4)*(1+($C$5/$C$3))),E58)

    What I would like to add to this if statement is as follows,

    1. Check to see if E58=0, then select D58
    2. Take the value of D58
    3. Then check to see if H58="Retailer"
    4. Then multiply the value of D58*(1+($C$5/$C$3)
    5. However, if H58="Internal"
    6. Then use the original formula of IF(E58=0,(D58*(1+$C$4)*(1+($C$5/$C$3)

    I hope that I was able to spell this out, can someone please help:)

  • Re: If Statement Help for Multiple Variables.


    can you post your worksheet with all the data in the correct place for me? it will help me get a better idea.

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: If Statement Help for Multiple Variables.


    Hi there,

    See how this goes:

    =IF(E58=0,IF(H58="Retailer",D58*(1+($C$5/$C$3)),IF(H58="Internal",D58*(1+$C$4)*(1+($C$5/$C$3)),0)))

    Regards,

    Robert

Participate now!

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