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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…