IF statement
 

I am currently working on a sales forecasting model with a IF statement that
says
=IF(jan!$m7="january".jan!$n7,0) which works very well as long as I am
looking only at Jan folder. My question is can you do a if statement that can
look from a jan folder through a Dec folder.
--
khorse

IF statement
 

Can you expand on that? I take it FOLDER is WORKSHEET?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kent Horsley" wrote in message
...
I am currently working on a sales forecasting model with a IF statement
that
says
=IF(jan!$m7="january".jan!$n7,0) which works very well as long as I am
looking only at Jan folder. My question is can you do a if statement that
can
look from a jan folder through a Dec folder.
--
khorse

IF statement
 

Why do you need to check for January? Doesn't the jan sheet have only
January data? If so, the If is unnecessary.

Regards,
Fred.

"Kent Horsley" wrote in message
...
I am currently working on a sales forecasting model with a IF statement
that
says
=IF(jan!$m7="january".jan!$n7,0) which works very well as long as I am
looking only at Jan folder. My question is can you do a if statement that
can
look from a jan folder through a Dec folder.
--
khorse