I need a formula to do the following:
If H89 is greater than or equal to R10, but H89 is less than or equal to R11 then the cell in question equals G89, else do nothing. Where R10, R11 and H89 are date cells.
Can someone help?
Many thanks in anticipation.
Last edited by LloydGilmore; 07-01-2014 at 09:56 AM. Reason: SOLVED
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try
=IF(AND(H89 > =R10,H89 < =R11),G89,"")
Hi there,
maybe:
Formula:Please Login or Register to view this content.
Hope it helps!
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Many thanks.
I was nearly there, but had an = in front of G89
Thanks for your help and speedy response.
Many thanks to you all.
I was nearly there, but had an = in front of G89
Thanks for your help and speedy response.
Try: =IF(AND(H89>=R10,H89<=R11),G89,"")
AND(...) will test for both conditions. If both are True, then IF = true and G89. Otherwise IF = False and returns "".
You can add text inside the "" to use as error flag. If statement is False, it will return the text string to alert you H89 is out of range.
Last edited by ratpackinc; 07-01-2014 at 09:56 AM. Reason: add more detail
Silly questions are cheaper than mistakes
Glad to help, thanks for the feedback.
Help!!! I need help with a conditional formatting formula that will:
Column G is all dates
For all of column G, if date is today plus no more than 7 days then, I choose a color:
+
For all of column G, if date is today and more than 8 days but no more than 14 days, then I choose another color:
+
For all of column G, if date is today and more than 15 days, then I choose a 3rd color
BlairBizz
Administrative Note:
Welcome to the forum.
We are happy to help however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4
If you are not familiar with how to start a new thread see the FAQ:
How to start a new thread
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks