Formula in a Cell with condition?

		Microsoft Office Forums > Microsoft Excel > Excel
Formula in a Cell with condition?

FAQ

Mark Forums Read

Thread Tools

Display Modes

07-17-2010, 03:25 AM

Learner7

Windows XP Formula in a Cell with condition?

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

Formula in a Cell with condition?

Hi,

How to write the formula in a cell as per the following condition?

Cell E10 = Start Date
Cell F10 = End Date

Cell H10 = Current Date

If StartDate (E10) is less or equal to CurrentDate (H10) then
=SUM(H10-E10+1)
Else
=SUM(H10-F10+1)

I need to write this formula in Cell J10.

Please help.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
Protect formula in cell?	markg2	Excel	4	05-24-2010 11:50 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
Retrict Method Condition	markp	Outlook	0	12-22-2005 05:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:05 AM.