View Single Post
 
Old 07-16-2010, 11:38 PM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default 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.
Reply With Quote