I need an excel formula to compliment or aid my current
Budget: $30 – $250 AUD
In my worksheet, formula in cell J73 is =IF(AND(O73="S",I73<C73),"EXIT","")
and in cell L73 is =IF(AND(O73="S",I73<C73),"EXIT","")
this works well but I only want the first result to show, not other results until cell O changes from L to S or S to L.
Attached are two files saying what I have and what I would like.
and in cell L73 is =IF(AND(O73="S",I73<C73),"EXIT","")
this works well but I only want the first result to show, not other results until cell O changes from L to S or S to L.
Attached are two files saying what I have and what I would like.