IF Function Question
Hello! I was wondering if there was a way to complete the following using an IF function:
I need this to happen but I am not sure how to insert the date:
If cell A1 is greater than .99 insert yesterdays date into cell B1, if it's </= do nothing.
I can't figure out the date part or if maybe I should be using a different formula?
Thank you!!
Kyle
Formula:
Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Perfect that worked!
Thank you!!
Kyle
Actually I have one final question please, if you don't mind:
if cell A1 is greater than .99 copy content of cell a1 to b1 - if that makes sense.
Cheers!
Kyle
Your initial request was...
Has that now changed?If cell A1 is greater than .99 insert yesterdays date into cell B1, if it's </= do nothing.
If so, then simply replace the TODAY part, with your new cell ref
If that was not what you wanted, please try to explain again?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
No that worked too, thank you!! 😀
Happy to help, mehmetcik did the heavy lifting though
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks