Remember Me?

#1
October 28th 04, 01:19 AM
A formula to check differrent cells

I'm new to this site, but I'm learning. I should have left an example of the
formula I'm currently using.

IF('Calculations'!C8=1,'Daily Reports'!A1,IF('Calculations'!G8=1,'Daily
Reports'!AH1,IF('Calculations'!K8=1,'Daily
Reports'!BM1,IF('Calculations'!O8=1,'Daily
Reports'!CS1,IF('Calculations'!S8=1,'Daily Reports'!DY1)))))

The = is just looking to see if a date is present. If not, check the next
cell, and so on.
Actually, this works fine, but I have 899 cells that need this formula. Of
course the reference points would change.

Is there a shorter formula I could use???

Carl

I'm using Excel 2000. I created a workbook for viewing and printing daily
reports. 1 report for each work day in a month. In the sheet for
calculations, I'm pulling data from the reports on another sheet. On the
first sheet "my home page" I have buttons, "with dates above" linked to each
report. I need every link on my calculations sheet, "numerus", to check for a
date entry on the home page to determin which report to pull data from. I was
useing IF THEN formulas, but each on needed 5. With all the links I have it
will take me a month to write them all. Is there an easyer way to do it?
Carl

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Slainteva Excel Discussion (Misc queries) 2 January 19th 05 08:25 PM rdavia Excel Discussion (Misc queries) 2 January 18th 05 05:29 PM Manuel Excel Discussion (Misc queries) 1 January 13th 05 03:52 PM Anthony Slater Excel Discussion (Misc queries) 3 January 4th 05 03:03 PM Mike A. Excel Discussion (Misc queries) 2 December 8th 04 05:35 PM

All times are GMT +1. The time now is 05:49 PM.