Excel If formula multi tabs

[dprayner]

Hi good people.

I am trying to pull information from one sheet and test to see if it is greater than 1300. If it is I want to put a 1 in the cell and if not, leave the cell blank. I have this so far: If('Items Proc"d by Req Code'!S6>1300,1,0). This comes up with an REF error. Any suggestions? DAVE

 

[firefytr]

The quote is screwing you up. Lose the quote and try again. If it's in your sheet name, take it out of there as well.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[dprayner]

Hi Zach.

I suspected the quote. The tab has a hyphen (Proc'd) and since it is not my spreadsheet, I can't change the name. I read something that said to change the ' to " if the formula is already in ' '.

DAVE

 

[firefytr]

That is not a quote, it's two apostrophe's.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci