LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kay Kay is offline
external usenet poster
 
Posts: 129
Default Re-post Formula

Start date March 23, 2006 (Cell K3)

July to June (D7:O7)

I have result D8+D9-10 (In D11) and I dragged this formula across to O11.

I want a formula that will over ride the month of march only L11 (with is
under the month of March) to be = 1or less than 1(=<1). This should be in
reference
to Month in K3. See example below. March as 3 and I need it to be 1 or less
to go forward to april even if they are not used. ( it should be reference to
March start month in K3



july aug sept oct nov dec jan feb mar apr may june (D7:O7)
start bal. 1 2 0 0 0 2 2 2 2 1 0
0 (D8:O8)
earned 1 0 0 0 2 0 0 0 1 0 0
0 (D9:O9)
used 0 2 0 0 0 0 0 0 0 0 0
0 (D10:O10)
Balance 2 0 0 0 2 2 2 2 3
(D11:O11)
--
KK
 
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
COPYING FORMULA CONTAINING NAMES... ( 2ND POST) Bricol Excel Worksheet Functions 5 July 22nd 08 01:38 PM
COPYING FORMULA CONTAINING NAMES... ( 2ND POST) Bricol Excel Discussion (Misc queries) 3 July 22nd 08 01:38 PM
Re-post VBA into Formula joesf16 Excel Worksheet Functions 5 May 6th 07 08:27 AM
Formula Help - Not Sure Where to Post tompal Excel Discussion (Misc queries) 4 January 12th 06 09:47 PM
Formula to post data in another spreadsheet taxmom Excel Worksheet Functions 5 March 17th 05 01:02 AM


All times are GMT +1. The time now is 12:19 AM.

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"