excel if statements

  Legolas 21:01 29 Jul 2009
Locked

Calling all you excel experts, I will try and explain what I am trying to do. I want the value .25 to be entered automatically into say cell A1 if the value in say cell A2 is 1 or 2. If the value in A2 is greater than 2 then I want the value .40 to be entered automatically into cell A1.

I hope this is clear, I have been fiddling with this all day but my knowledge of if statements is very limited.

  Legolas 21:23 29 Jul 2009

Sorry made a mistake in the above for A2 please read B1 so it should read:

I want the value .25 to be entered automatically into say cell A1 if the value in say cell B1 is 1 or 2. If the value in B1 is greater than 2 then I want the value .40 to be entered automatically into cell A1.

  VoG II 21:24 29 Jul 2009

Not sure what you want to happen if A2 doesn't meet any of those conditions so I've left it blank. In A1

=IF(OR(A2=1,A2=2),0.25,IF(A2>2,0.4,""))

  VoG II 21:25 29 Jul 2009

=IF(OR(B1=1,B1=2),0.25,IF(B1>2,0.4,""))

  Legolas 20:13 01 Aug 2009

Thanks for the reply. That works great.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?