IF statement

  • Thread starter Thread starter Kent Horsley
  • Start date Start date
K

Kent Horsley

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.
 
Can you expand on that? I take it FOLDER is WORKSHEET?
best wishes
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average 2
Conditional/variable sum?? 7
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) 6
Using multiple IF statements 1
how do I average only certain cells based on month? 3
IF Statments in Excel 5
Specify columns to add for months MTD Diff 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Back
Top