#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Hi,
Code:
=IF(E10<=H10,H10-E10+1,H10-F10+1) |
|
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 |