Questions

Excel - using the IF function

+
0 Votes
Locked

Excel - using the IF function

65roffey
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
  • +
    0 Votes
    mauger81

    =IF(AJ2=0,0,(AJ2-AI1))

    Is the formula you want to use. Basically, what that says is If AJ2 equals 0, then I will return 0. If it does not equal 0, I will return (AJ2-AI1). Mind you, this doesn't have a constraint about keeping the target cell a positive value. it only looks at whether AJ2 is zero or non-zero.

    +
    0 Votes
    LocoLobo

    =IF(AJ2=0,0,IF(AJ2>=1,(AJ2-AI2),"Error"))

    In place of error you need to put in what you want to happen when AJ2 is between 0 and 1 exclusive (i.e. 0.5). Or if you KNOW AJ2 will never be other than 0, or 1 and greater then don't worry about it.

  • +
    0 Votes
    mauger81

    =IF(AJ2=0,0,(AJ2-AI1))

    Is the formula you want to use. Basically, what that says is If AJ2 equals 0, then I will return 0. If it does not equal 0, I will return (AJ2-AI1). Mind you, this doesn't have a constraint about keeping the target cell a positive value. it only looks at whether AJ2 is zero or non-zero.

    +
    0 Votes
    LocoLobo

    =IF(AJ2=0,0,IF(AJ2>=1,(AJ2-AI2),"Error"))

    In place of error you need to put in what you want to happen when AJ2 is between 0 and 1 exclusive (i.e. 0.5). Or if you KNOW AJ2 will never be other than 0, or 1 and greater then don't worry about it.