I have a drop down list that has hours in thirty min intevals and then several text selections. I have a formula =0.3544+a3 to add 8.5 hours to the time entered. I need to have it return a blank cell if there is text in cell a3. How do I modify this to work for me. All help is greatly appreciated...thank you
Last edited by kulik09; 05-02-2010 at 12:15 AM. Reason: Rule infraction
Hello & Welcome to the forum,
Try...
=IF(ISTEXT(A3),"",0.3544+A3)
Hi Kulik, welcome to the forum. Try this:
=IF(ISTEXT(A3), "", 0.3544 + A3)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That solved my problem, thank you so much!!! I am new to Excel and trying to get my head wrapped around it...again thank you!!
Kulik09,
If you are satisfied with the response you have received, please make the thread as solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks