Help with an Excel Formula needed!

  ShorN 09:44 29 May 05
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 05

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

  ShorN 10:17 29 May 05

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

  Cesar 08:56 31 May 05

Bump

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…