Forum Discussion
Solved
IF FUNCTION AND ROUNDUP
I have a current formula - =ROUNDUP(($A$1-J18)/7,0) This tells me how many weeks have past from one date to another. What I want to add is that if another cell has a date in it that has pass...
When it's something like this
=WEEKNUM(IF(ISBLANK(<hired off date>),TODAY(), <hired off date>)) - WEEKNUM(<hired on date>)
Perhaps plus 1 depends on how do you calculte not full week, as zero or as 1.
Hi Zoe Jeffery,
Good day,
It is my pleasure give some suggestion to your problem.
Please try to use below formula. I am not sure how mutch it may work respect to your requirement.
Please find attached work sheet and study.
=IF(ROUNDUP(($A$36-B39)/7,0)>$C$36,"0",$A$36-B39)
Regards,
Manoj P.
Hi, I saw your reply to a formula question similar to what i am trying to accomplish. I have the following formula that works mostly how i want it to, however i need the "G31/75" portion to round up.
=IF($G$31<=1500,($G$31/75),0)
Can you help me?
Thank you in advance
JamesWise , why don't you use ROUNDUP() function?
