Formula Help

New Contributor

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.

3 Replies

@jami0704 

In L2:

 

=IF(I2=74.97,1.07,IF(I2=52.5,0.5,0))

 

Fill or copy down.

Thank you Hans. It did work for the 74.97 but when colum I is 57.59 is returned zero in column L, I would like it to return 0.50

@jami0704 

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})