Hello,
So i have to get a formula based on a cell to automate some paychecks.
In column M i have the data i want to check
i have 5 VALUES, CTT40, CTT30, CTT20, RV, AF
Based on those values i want to get:
if column M CTT40: =+IF(Q5>=70;0,7*AG5;
if column M CTT30: =+IF(Q5>=21;(2,65*U5)+500;
if column M CTT20: =+IF(Q5>=21;(2,65*U5)+500;
if column M RV: =0
if column M AF: =U5*1,35
Its possible to make this?
Thanks in advance!
Bookmarks