I wonder if there is a wonderful tech person out there that could help me with a problem I’m having in Excel.
What I’m trying to do is: in cell AK2, if the value for cell AJ2 is 0, then for it to show 0, however, if it is more than/or equal to 1, then it should deduct cell AJ2 from AI1. This is the formula that I’ve tried to use and it is telling me I’m useless and that I should just put the laptop in the bin.
=IF(AJ2,0,0), IF(AJ2,>1,(AI2-AJ2))
Please help!
Thanks,
Donna