Hello All,

Having trouble adding criteria to an IF function.

Using in Cell S3517:
=IF(L3517=0," ",(ROUND(-L3517*0.01,2))+L3517.

Need to add:

IF "SEARS" apprears in E3517, disregard other criteria and put the amount
from cell L3517, with no 1% discount and no rounding, in cell S3517.

Is this possible?

Thank you,