MULTIPLE CELLS - IF STATEMENT QUESTION

kinselas · Mar 13, 2003

I HAVE THIS FORMULA...BUT I WOULD LIKE TO ADD THE MANDATORY CELLS...G9 AND K9 AND O9 >1 PLEASE HELP WITH THE SYNTAX

=IF(D9>1,"OK TO PRINT","ALL MANDATORY CELLS HAVE NOT BEEN M66&quot

Zathras · Mar 13, 2003

It looks like you have text in M66 that you want appended as part of the message, so the end formula looks something like this:

Code:

=IF(

Code:

AND(D9>1,G9>1,K9>1,O9>1)

Code:

,"OK TO PRINT","ALL MANDATORY CELLS HAVE NOT BEEN "

Code:

&M66

Code:

)

PeterMoran · Mar 13, 2003

Hi kinselas,

Try this, if I understand correctly:

=IF(AND(D9>1,G9>1,K9>1,O9>1),"OK TO PRINT","ALL MANDATORY CELLS HAVE NOT BEEN M66&quot

This requires all cells to have values > 1, if anyone will do then change the AND to OR.

Good Luck!

Peter Moran
Two heads are always better than one!

kinselas · Mar 16, 2003

Zathras & Peter Thanks for your help

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

MULTIPLE CELLS - IF STATEMENT QUESTION

kinselas

IS-IT--Management

Zathras

Programmer

PeterMoran

MIS

kinselas

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor