IF formula.

    Hi All,


    I'm trying to make a cell automatically calculate total number of items required.


    I only need the cell to input if cell D19 is less than 40 and if D19 is blank leave D24 blank.


    The formula I've tried is =IF(OR(D19="","",0),OR((40-D19)<0,0,(40-D19))) but this just brings up #VALUE!


    I've tried variations of the formula and can get the cell to work out if D19 is less than 40, but then when there is nothing in D19 it keeps putting 40 and I can't get the first bit of the formula to work.


    Is it possible to do this?


    Please help.


    Thanks.

    Try


    =IF(D19<40,"your result","")


    where "your result" is replaced by what you want to return to D24 when D19<40

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login