hi guys,

i think this thread may be the place i need to find out a similar conditional formula,


i need a cell (K) to make a calculation based on IF the previous cell (I) goes below 1.5 X the value of a cell (J) - the calculation needs to be the difference between cell (I) and 1.5 X the value of cell (J)

IF it isnt below 1.5 X cell (J) THEN return blank cell

i think thats what i need i might be overthinking this but any help would be appreciated.

thanks

jimmy