If Formula Help

Closed
Report
-
 Trowa -
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Try this =if(and(a1="LL",a1="P"),0.37,1.08)
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?
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Sorry a small change Try this =if(or(a1="LL",a1="P"),0.37,1.08)
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
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