Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mystical_ways
 
Posts: n/a
Default How do I get this formula to work?

OK this may be a long discription but hopefully you will understand it.
I work on attendance, inputing students hours, this is how the spread sheet
is set up

On the left of the sheet are the names of the students 1-80 rows, on the
top are the days in months from june 6th till now going across from left to
right, directly below the month colums are the spaces for the days to input
the total hours, directly to the right of that info going from top to bottom
left to right are the total hours, scheduled hours and percent attended. The
total hours and percent attended have their own formulas of course.

This is the formula I was trying to use:
=IF(AT2:AW80<=3.0,AZ2:AZ38+12

Now if all of that made any sense, PLEASE,PLEASE,PLEASE, I want the colum
with total hours, which lets say are 60, to add 12 every week 60, 72, 84 e.c.t
If any of that did not make sense I will re-write this again till I get it
right.
Thanks again,
Mystical




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
IF / VLOOKUP formula won't work until saved tawtrey(remove this )@pacificfoods.com Excel Worksheet Functions 2 August 4th 05 11:55 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
formula won't work tink13ub Excel Worksheet Functions 1 January 17th 05 06:59 AM
formula won't work Linette Excel Worksheet Functions 0 January 17th 05 06:05 AM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"