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.

Samsung Galaxy S8 review

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

This 2D animation about monsters is illustrated in a Van Gogh painterly style

Siri not working? Try these troubleshooting fixes