 # 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)

• 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

• Re: If Statement Help for Multiple Variables.

I just wanted to say thank you for your help. The last formula was helpful.

Thanks ## Participate now!

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