Formula in a Cell with condition?

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

FAQ

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 »

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 07:11 AM.