...new to excel and the forum.
i have a question so once i find where to do so I will.
hope(no doubt)someone can help me out?
thanks
...new to excel and the forum.
i have a question so once i find where to do so I will.
hope(no doubt)someone can help me out?
thanks
Hello gwennita,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
ha sorry...thought this was the introduction bit.
here is my formula
it is almost working but not quite
=IF(K3="",IF(0<(A3+M3)<=52,(A3+M3),(A3+M3)-52),IF(0<(K3+M3)<=52,(K3+M3),(K3+M3)-52))
if K3 is empty(no number)(logical test) then =A3+M3
however we talking number of weeks in a year which between 1 and 52
so result can be 0 or below nor above 52
ends that bit IF(0<(A3+M3)<=52,(A3+M3),(A3+M3)-52)
(value if true)
however if there is a data(number) in K3 then =K3+M3
with the same constrains of maximum of 52 weeks
ends that bit IF(0<(K3+M3)<=52,(K3+M3),(K3+M3)-52)
(value if false)
it is a bit hand made and no idea if if would make sense to anyone else than me
it seems to all work in sections but put together i can still obtain a negative total of weeks!
help if you can
thanks
Last edited by gwennita; 12-15-2014 at 06:22 PM.
I am aware my problem lay in result needing to remain between 1 and 52
when it goes above 52 result goes back to count 1..etc...
(A3+M3)-52) this is not correct as already M3 itself can be greater than 52 and that would fail the result
it is too simplistic
please help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks