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, 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?