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.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

iPad Pro 12.9 vs Surface Pro 5