IM AM TRYING TO RUN AN IF FORMULA ON MORE THAN 1 CELL
EXAMPLE MY CURRENT FORMUL WORKS ON 1 CELL
=IF((AND(D7=D10,E7=E10,F7=F10,G7=G10,H7=H10)),"YES","NO")
I NEED TO RUN IT ON ROWS VERSUS CELL
EX
=IF((AND(D7=D10:D22,E7=E10:E22,F7=F10:E22,G7=G10:G22,H7=H10"H22)),"YES","NO")
DOESNT WORK PLEASE HELP I HAVE 24 HRS BEFORE THIS IS DUE I WILL EAMIL THE SPREADSHEET IF THAT WILL HELP!!!!
AM I USING THE WRONG FUNCTION
EXAMPLE MY CURRENT FORMUL WORKS ON 1 CELL
=IF((AND(D7=D10,E7=E10,F7=F10,G7=G10,H7=H10)),"YES","NO")
I NEED TO RUN IT ON ROWS VERSUS CELL
EX
=IF((AND(D7=D10:D22,E7=E10:E22,F7=F10:E22,G7=G10:G22,H7=H10"H22)),"YES","NO")
DOESNT WORK PLEASE HELP I HAVE 24 HRS BEFORE THIS IS DUE I WILL EAMIL THE SPREADSHEET IF THAT WILL HELP!!!!
AM I USING THE WRONG FUNCTION