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?