Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 22

formula adjustment

I am using the following formula with works great, but I need to add
something to it.

=IF(AND(TODAY()=C35,TODAY()<=D35,ISBLANK(G2)),C2+ I2,"")

In addition to the criteria in this formula I need to add logic that says:

If G2 is "not" blank, give the sum of C2 - H2 + I2

My problem is I don't know how to include all of this logic in a single
formula. Any ideas?

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
linear adjustment in excel	[email protected]	Excel Discussion (Misc queries)	3	August 27th 07 04:50 PM
Formula Adjustment - Help	Josh O.	Excel Worksheet Functions	1	January 24th 07 02:58 PM
automatic adjustment	daidipya	Excel Discussion (Misc queries)	1	June 8th 06 02:46 PM
Inflation Adjustment	dimitmant	Excel Discussion (Misc queries)	1	November 17th 05 09:06 AM
Copy without Adjustment	Gary's Student	Excel Discussion (Misc queries)	5	May 1st 05 11:04 PM

All times are GMT +1. The time now is 05:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us