Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2230002%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2230002%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20put%20a%20formula%20in%20to%20return%20a%20value%20and%20I%20am%20stumped.%20In%20my%20%22column%20I%22%20there%20are%20several%20dollar%20amounts.%20I%20want%20in%20%22column%20L%22%20a%20value%20returned.%20For%20example%20If%20it%20is%20%2474.97%20in%20column%20I%20then%20in%20column%20L%20it%20would%20have%20a%20value%20of%20%241.07.%20If%20it%20is%20%2452.50%20then%20return%20a%20value%20of%20%240.50.%20All%20other%20amounts%20would%20return%20a%20zero.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2230002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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})