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!