Microsoft Excel IF AND OR

[funkylad20]

Ok, another more simple one...
If I have two options in cell A1 (3.70 and 4.00)
I now want cell A2 to read as:
20 if A1 is 3.70 and
25 if A1 is 4.00.

Any ideas?!
Excel is doing my nut in (not a good idea to do last thing on a Friday at work!!)!

[dave2297]

=if(A1=3.7,"20","25")

[dave2297]

or - if you need the value, remove the ""'s

[Nosha123]

Give it up and use a Mac instead.. that PC ***** aint worth the hassle! ha ha ha

[funkylad20]

Simple! Cannot believe I didn't suss that one out myself...thanks Dave.

Nosha, if my employers could afford MACS for everyone, I am sure they would [ even though they're only really good for arty c**p and posers ;o) ]

[dave2297]

yvw :)

[funkylad20]

Actually.......
just tried it, if I delete cell A1, it still has 25 in cell A2. How do I make it read as blank if noting is entered in cell A1??

[dave2297]

=if(a1=3.7,20,if(a1=4,25,""))

[dave2297]

sorry, when you said that you had 2 options I didn't realise that you actually meant 3 options (ie a blank cell)

Excel eh?

lol

[funkylad20]

Ok, it doesn't work.......ARGHHHHHHH!!!

[funkylad20]

DID IT!
Don't know how andI am past caring on this one now, but, this was the answer...
=IF(A2=3.7, "20", IF(A2=4, "25", ""))
Perhaps has something to do with spaces? Or Karma? Or Gof?! Who knows......but it works! Thanks people!

[dave2297]

ain't that what i said....except with the cell references that you needed?

[funkylad20]

Gof or God....Jeeze, can you tell I am an atheist?!