# IF FUNCTION

#### JHELP

##### New Member
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

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
JHELP,

It's hard to tell what "=" means. If D7 is blank, do cells that evaluate to zero "=" D7? Does the sum of all values in D10:D22 need to equal the value of D7? Does each cell in the range D10:D22 need to individually equal D7? Will D7 and D10:D22 hold numbers or text?

Dufus

A couple of things:

You have quotation marks instead of the colon for H10:h22. If you copied it from your formula that will be an error

Try Ctrl+shift+enter to enter it as an array formula. I entered your formula into a blank worksheet with CSE and it showed up as yes, which is right as blank = 0

Finally, Turn off Caps lock as it gives the impression you are shouting at people

Good luck

Thank you to all. I think the problem is I am trying to use an if function to determine if any cell the row ='s a single cell. I get "yes" as long as all the cells in the row match the "=" cell. If they do not I get no. I want to get a "yes" if any cell in the row matchs the "="cell.

example = if c7 ='s any cell in row c8:c25 i get a yes versus a no

am i making any sense??? im having a hard time understanding myself at this point

One way would be with COUNTIF

e.g.

=IF((AND(COUNTIF(D10:D22,D7)>0,COUNTIF(E10:E22,E7)>0,COUNTIF(F10:F22,F7)>0,COUNTIF(G10:G22,G7),COUNTIF(H10:H22,H7)>0)),"YES","NO")

brother thank you sooo much you are a god sent and i owe you man you have wonderful day and thank you soooooooo much for taking the time out to help me thank you thank you

Thank you to all. I think the problem is I am trying to use an if function to determine if any cell the row ='s a single cell. I get "yes" as long as all the cells in the row match the "=" cell. If they do not I get no. I want to get a "yes" if any cell in the row matchs the "="cell.

example = if c7 ='s any cell in row c8:c25 i get a yes versus a no

am i making any sense??? im having a hard time understanding myself at this point

=IF(ISNUMBER(MATCH(C7,C8:C25,0)),"Yes","No")

Replies
6
Views
386
Replies
1
Views
284
Replies
2
Views
442
Replies
0
Views
199
Replies
3
Views
231

1,211,987
Messages
6,105,226
Members
447,957
Latest member
Basildon

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back