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.
|