hi guys
i am absolutely useless with formulas
how can i write if cell DT2 is higher than cell EO2 then return the answer from L2 but if EO2 is higher than DT2 then return the answer from T2
thank you
hi guys
i am absolutely useless with formulas
how can i write if cell DT2 is higher than cell EO2 then return the answer from L2 but if EO2 is higher than DT2 then return the answer from T2
thank you
Try this:
=IF(DT2>EO2,L2,IF(EO2>DT2,T2,"what if draw?"))
You need to specify what to do if the two cells are equal, i.e. change "what if draw?" to what you want in that case.
Hope this helps.
Pete
Thanks pete
as superb as ever
much appreciated
TryFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You're welcome. Thanks for the rep.
Pete's solution was much more comprehensive
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks