Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF
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, |