EXCEL 97 - USE "IF" IN CONJUNCTION WITH "AND/OR"

  TABBYCAT 18:26 08 Dec 2003
Locked

IS THERE A WAY OF USING THE "IF" FUNCTION IN CONJUNCTION WITH "AND" OR "OR" IN EXCEL 97?
FOR EXAMPLE:
I WANT CELL A1 TO DISPLAY "CORRECT" IF BOTH B1 AND B2 ARE VALUE 10 OR GREATER; UNLESS BOTH ARE IT SHOULD DISPLAY "ERROR"
I'VE TRIED ALL SORTS OF PERMUTATIONS BUT EXCEL WILL NOT ACCEPT ANY OF THEM.

  pc moron 18:37 08 Dec 2003

=IF(AND(B1>=10,B2>=10),"CORRECT","ERROR")

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

Elsewhere on IDG sites

HTC U12 Plus review: Hands-on

There's a new Gradient tool coming to Adobe Illustrator

Best Android emulators for Mac

Les drôles de questions à poser à votre assistant Google Home