Previous Topic Next Topic

If Formula Help

Closed
Steve - 12 Aug 2009 à 05:48
 Trowa - 17 Aug 2009 à 09:03
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 responses

Réponse 1 / 3
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
15 Aug 2009 à 02:35
Try this =if(and(a1="LL",a1="P"),0.37,1.08)
Steve
15 Aug 2009 à 07:53
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?
Réponse 2 / 3
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
15 Aug 2009 à 23:19
Sorry a small change Try this =if(or(a1="LL",a1="P"),0.37,1.08)
Steve
17 Aug 2009 à 05:56
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
Réponse 3 / 3
Trowa
17 Aug 2009 à 09:03
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
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses