How can I write the following (whole) formula in a single cell?

Learner7 · #1 07-16-2010, 11:38 PM

Hi,

How can I write the following (whole) formula in a single cell (Cell G10)?

If Cell F10 (Which has "Current Date") value is less or equal to Cell E10 (Which has "Start Date") value, then it should be
=SUM(F10-E10+1) in Cell G10

If Cell F10 (Which has "Current Date") value is heigher than Cell E10 (Which has "Start Date") value, then it should be =SUM(C10) in Cell G10

Thanks in advance for any help.

Regards.

ConneXionLost · #2 07-19-2010, 10:06 AM

Hi,

Code:

=IF(F10<=E10,F10-E10+1,C10)

Cheers,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Protect formula in cell?	markg2	Excel	4	05-24-2010 11:50 AM
Pasting multiple photos - one photo per cell in a single oepration	mccruise	Word	0	04-07-2010 04:13 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM