IF AND formula

[tomvh444]

I have been using the following formula that works fine for E718. =IF(J718="","",IF(C718="vs",J718,IF(C718="@",J718-10)))

But I now need to modify this formula to address the following additional condition. When C718 = "@" I now need to have two possible results based on the value in J718 not just the one. IF C718 = "@" and J718 is also greater than 100 then the value is J718-10. However, if C718 = "@" and the value in J718 is less than 101 then the value is J718 -200.

[leelnich]

Hi tomvh444, not sure if this is what you want:
=IF(J718="","",IF(C718="vs",J718,IF(C718="@",IF(J718>100,J718-10,J718-200))))

I assumed J718 is an integer, otherwise your conditions overlap.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[tomvh444]

J718 is an integer and the new formula does the job. Once again many thanks for the help.