Rick,
I think you'll need to do it like this:
=IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2))+L3517)
otherwise you'll be trying to add a number onto " " when L3517 is zero.
Pete
"Rick Rothstein (MVP -
VB)" wrote in
message ...
This should do what you want...
=IF(L3517=0," ",IF(E3517="SEARS",0,ROUND(-L3517*0.01,2)))+L3517
Rick
"Susan" wrote in message
...
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,