Forum Discussion
need help with a formula to place an X in a cell when values in another column reach multiples of 7
I am working on a timekeeping worksheet that keeps track of anticipated vacation time. For each 7 hours of overtime worked, the time is kept in a "bank" to be used for vacation days. 7 hours of ove...
Hi Renee,
Please try this formula in column H.
=IF(OR(D1>=7,D1>=14,D1>=21),"X","")
I hope I understand you well!
Regards
Thank you! I will give this a try.
Will I be able to carry the formula down column i? So that the hours in column D can go higher than 21 (and there will be more than 3 "X" 's?
Will I be able to carry the formula down column i? So that the hours in column D can go higher than 21 (and there will be more than 3 "X" 's?
Hi Renee,
Please note that formula returns just single X if values in column D go higher than 7 or 14 or 21.
If you want it to return more that one X based on the number, so please try this instead:
=IF(D1>=21,"XXX",IF(D1>=14,"XX",IF(D1>=7,"X","")))
It will give you a result like this:
Please test it, and tell me what you think.
And if you want to adjust the formula so that it will return more than XXX, please provide more details about that because the above formula will return XXX if the value in column D is greater than or equal to 21.
Regards
