Mar 23 2021 08:18 AM
Good morning,
I am trying to put a formula in to return a value and I am stumped. In my "column I" there are several dollar amounts. I want in "column L" a value returned. For example If it is $74.97 in column I then in column L it would have a value of $1.07. If it is $52.50 then return a value of $0.50. All other amounts would return a zero.
Mar 23 2021 08:42 AM
Mar 23 2021 08:47 AM
Mar 23 2021 08:57 AM
Well, you mentioned that you wanted the formula to return 0 for all values other than 74.97 and 52.50, so that's what it does...
Perhaps this will be better?
=LOOKUP(I2,{0,52.5,74.97},{0,0.5,1.07})