# ROUND UP FORMULA with IF Function

#### JeysJeys

##### New Member
I need help with roundup in an if statement.

=ROUNDUP(MONTH(\$G7)/3,0)

I've tried everything that I can think of with no luck.

Any help would be appreciated.

I need Quarter come from Date but if there is not date formula show 0 not value.

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### Joe4

Try:
Code:
``=IF(\$G7=0,0,ROUNDUP(MONTH(\$G7)/3,0))``

#### JeysJeys

##### New Member
Try:
Code:
``=IF(\$G7=0,0,ROUNDUP(MONTH(\$G7)/3,0))``

Hi,

Thanks a lot Jeo

Replies
20
Views
173
Replies
1
Views
208
Replies
15
Views
445
Replies
4
Views
109
Replies
11
Views
391

1,136,314
Messages
5,675,035
Members
419,546
Latest member
RobWayCot

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back