Hi all, I am new to the forum and hope I am posting in the right place.... my problem is this: I need a cell to display one of three options depending on which of the three values has been sent to another cell via the MAX function, I have tried the following but it does not work:
= IF(M6=C3,L3),IF(M6=F3,L4),if (M6=i3,L5)
can anyone help???
thanks for taking the time to read this post
Phil
Bookmarks