If Formula Help

Closed

Steve - Aug 12, 2009 at 05:48 AM
Trowa - Aug 17, 2009 at 09:03 AM

Hello,

I am currently using the latest version of excel and am having trouble getting a forumla to work. It should be very simple, but i just cant get it right.

Basically, i need a formula to go into cell A2 that will read the value in A1 and enter either .37 or 1.08 in cell A2.
A1 will either be the letters LL or the letter P.

Any help would be greatly appreciated.

If Formula Help
Logitech formula vibration feedback wheel driver - Download - Drivers
Excel grade formula - Guide
Number to words in excel formula - Guide
Credit summation formula - Guide
Date formula in excel dd/mm/yyyy - Guide

3 responses

Answer 1 / 3

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 15, 2009 at 02:35 AM

Try this =if(and(a1="LL",a1="P"),0.37,1.08)

Steve
Aug 15, 2009 at 07:53 AM

Thanks for the suggestion, but it doesnt work. Just comes back with a return of 1.08, whether i eneter LL, P or nothing in A1.

Any other ideas?

Answer 2 / 3

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 15, 2009 at 11:19 PM

Sorry a small change Try this =if(or(a1="LL",a1="P"),0.37,1.08)

Steve
Aug 17, 2009 at 05:56 AM

Thank you once again for your efforts, and i think we are close to it working, but when i test it now and enter LL it changes the value to .37 which is correct, how ever when i put a P in it doesnt change to 1.08?

all the best
Steve

Answer 3 / 3

Trowa
Aug 17, 2009 at 09:03 AM

Try this one:

=IF(A1="LL",0.37,IF(A1="P",1.08,""))
If A1 is LL then A2 will be 0.37. If not check if A1 is P. If true A2 will be 1.08, if false A2 will be blank.

Best regards

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!