Hello,
Is it possible to have the a forumla work as the true answer in an IF function.
i.e. if the column has full days, then use forumla - I have the below but it does not use the formula, it just types it in.
Am trying to total that if cell has full day, then calculate 3 days after of the date in column U2 whcih works if i just put in the formula but if used with the IF function, it does not calculate.
=IF(Y2="full day","=DATE(YEAR(U2),MONTH(U2),DAY(U2)+3)")
Any ideas?
How about?
=IF(Y2="full day",U2+3,U2)
or
=U2+IF(Y2="full day",3,0)
you may have to format the cell as Date if you are getting a 5 digit number result....
Last edited by NBVC; 01-26-2012 at 11:08 AM.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Thanks very much NBVC.
One more question, if the answer is false, what do i add so that the cell stays blank? as when i drag this, it puts in the date.
Try:
=IF(Y2="full day",U2+3,"")
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Thanks very much, you just saved me a lot of time. Very much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks