Excel Worksheet Problem

Microsoft Office professional edition 20...
March 12, 2010 at 13:50:17
Specs: Windows 2000
I have 250+sheets, summary sheet in excel. I did a formula an IF THEN statement it works ex; IF(sheet1'!$B$1<=5,sheet1'!$B$2,sheet1'!$B$3) but now have to repeat that formula 249 more time on my summary sheet.

See More: Excel Worksheet Problem

March 12, 2010 at 14:52:03

If you are trying to do the same as before then the initial 'formula' looks like this:

="XXXIF(Sheet" & G3 & "!$B$1<=5,Sheet" & G3 & "!$B$2,Sheet" & G3 &"!$B$3)"

The formula you posted has an extra ' in it,


or a missing '
depends on how you look at it.

The worksheet name can be used without single quotes if there are no spaces in the name, so =Sheet1!B1 is OK
but with a space it has to be ='Sheet 1'!B1


Report •
Related Solutions

Ask Question