Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 39

Calculating

I need a formula that can calculate the following:

If month($B$2) equal month (D10) the maximum it can calculate to is 1,
otherwise add D11+D12-D13
The formula is in D14. So one month that correspond with B2 is going to
have a value of 1 or less when you add row 11and 12 then minus13. while the
other will have the right result.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
calculating	Link[_2_]	Excel Worksheet Functions	14	May 30th 09 03:42 AM
CALCULATING A VALUE	Chris	Excel Discussion (Misc queries)	2	July 4th 08 02:36 PM
Not Calculating	Mike Dobony	Excel Worksheet Functions	14	November 18th 07 03:24 AM
Calculating Age	Mert	Excel Worksheet Functions	3	September 8th 06 06:38 PM
Calculating recurring date in following month, calculating # days in that period	Walterius	Excel Worksheet Functions	6	June 4th 05 11:21 PM

All times are GMT +1. The time now is 09:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us