I currently have this formula that only deals with 1 logical criteria. I'm trying to add more.
I would like the formula to Start with cell L2 if it contains a value greater than 0 then return that value otherwise move on to cell M2, if M2 has a value greater than 0 return that number, otherwise move on to R2, if R2 has a value greater than 0 than return that number. If none of these cells have values greater than zero than return blank
As always thank you!
Excel Formula:
=IF(L2="",M2,L2)
I would like the formula to Start with cell L2 if it contains a value greater than 0 then return that value otherwise move on to cell M2, if M2 has a value greater than 0 return that number, otherwise move on to R2, if R2 has a value greater than 0 than return that number. If none of these cells have values greater than zero than return blank
As always thank you!