Quote:
Originally Posted by -Ralph-
Thanks
Yeah, so in plain English cell J4 needs to say
Return £0.00, unless D4 equal to or greater than J2, in which case return E4; unless J2 equal to or greater than (C4/3)+D4, in which case go back to returning £0.00
Will need persistent $ signs for J$2, and $C4, $D4 and $E4
|
Something like =IF(($D4=>$J2),$E4,IF($J2=>(($C4/3)+$D4),0) making sure the cell format is set to output £X.XX.
Not sure if you might need a SUM between IF($J2=>(SUM($C4/3)+$D4), it's been a while.
I haven't got it installed on this pc but I might get a min at lunch/work Tues to have a pop.
Please let us know if you cracked it.