Help with an Excel Formula needed!

  ShorN 09:44 29 May 2005
Locked

Im trying to create a formula in Excel but im having some problems.
Im not even sure that it can be done!

Basically the cell that the formula is in must return a "yes" or "no".

I want the formula to reference three seperate cells in that row. Basically it should return a "yes" if the first cell has a value greater to or equal to 10000, the second cell is greater or equal to 4 and the third cell has a value of 1. Basically if it does match this criteria it should return with a "No".

Any help on creating this would be very apprciated
TIA!

  VoG II 10:06 29 May 2005

=IF(AND(A1>=10000, B1>=4, C1=1),"Yes", "No")

  ShorN 10:17 29 May 2005

Thats superb! thanks.
Its actually alot simpler than I imagined!

  Cesar 08:56 31 May 2005

Bump

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

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?