|Your going to need both an IF() an AND() function, something like:|
Although your calculation will have to be modified so Excel will understand it.
(ab-40)*0.8 is not a valid Excel calculation.
And Excel questions are best asked in the Office Software forum.
message edited by mmcconaghy