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.

3 replies

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)
0
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?
0
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)
0
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
0
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
0