#1
|
|||
|
|||
How can I write the following (whole) formula in a single cell?
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. |
#2
|
||||
|
||||
Hi,
Code:
=IF(F10<=E10,F10-E10+1,C10) |
|
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 |