I have a problem
I have cell A which shows true or false and I have cell B which shows true and false
Now I need the results in cell C
Which formula should give something like this:
IF A=True then deduct D2-6 else D2
and then check if :
IF B=True then deduct D2-3 else D2
Any ideas how can I nest those two conditions in one cell (C)
thnx