Question
August 15, 2007 at 08:16 AM
65roffey

Excel – using the IF function

by 65roffey . Updated 19 years, 2 months ago

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

This discussion is locked

All Comments