# Solved: Roundup within a if, product formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### Mcullin

=IF((PRODUCT(C6*B7)/144)<10, PRODUCT((C6*B7)/144*3.84+10)*1.3, PRODUCT(C6*B7)/144*3.84*1.3)

I need to figure out how to get this to round up the (C6*B7)/144) to the 0 decimal.

example would be 36"*15"=540/144=3.75 (I need 3.75 to roundup to 4) but let the rest of the formula continue. If less than 10 sq ft and \$10 fee *1.3. If 10 sq ft or more then *1.3 only.

Any help would be greatly appreciated.
Thanks,
Michael

#### Rockn

Use the ROUND function and the number of decimal points.

#### Mcullin

Using the round or roundup is kinda of obvious, my problem is where? do I replace Product?

#### Rockn

If(Round(Product(C6*B7)/144),0)<10

Something like that

#### Mcullin

=IF(ROUND(PRODUCT(D4*B5/144),0)<10, PRODUCT((D4*B5)/144*3.84+10)*1.3, PRODUCT(D4*B5)/144*3.84*1.3)
Didn't work on rounding up to the next whole square foot. But at least this time it did not give any kind of error either.

#### Rockn

Put the function alone into a cell and see if it is rounding correctly.

#### Mcullin

=ROUND(((D4*B5)/144),0) worked at rounding up but the second I add the product or if it stops working

#### Rockn

The product function is used to multiply values of cells. PRODUCT(A1,A2,etc)

You are already doing that with C6*B7 so you do not need the PRODUCT function at all.

#### Mcullin

Okay I got that the product does not need to be there for the short round up only formula, but what about a more complex one.
=IF(ROUND((D4*B5/144),0)<10,((D4*B5)/144*3.84+10)*1.3,(D4*B5)/144*3.84*1.3). This still calculates without the round up. or
=IF(ROUND((D4*B5/144),0)<10,product((D4*B5)/144*3.84+10)*1.3,product(D4*B5)/144*3.84*1.3)
neither of these are rounding up the sq ft to the next whole number and then calculating the rest of the formula. Even though the short round up formula does work to roundup only.
I do appreciate your patience and assistance and sorry if I am not communicatiing what it is I need.
Michael

#### Rockn

You will need to add the round function to each of the instances within the If function.

=IF(ROUND((D4*B5/144),0)<10,Round(((D4*B5)/144*3.84+10)*1.3),0),Round((D4*B5)/144*3.84*1.3),0)

I am not sure I put it in the correct place for your usage, but you should get the idea.

#### Mcullin

=IF((ROUND((D4*B5/144),0)<10,Round(((D4*B5)/144*3.84+10)*1.3),0),Round((D4*B5)/144*3.84*1.3),0)
This gives an error message as too few arguments. i think I tried this one yesterday night.

#### Rockn

You might be missing a round bracket at the end

#### Rockn

=if(round((d4*b5/144),0)<10,round(((((d4*b5)/144)*3.84)+10)*1.3,0),round((((d4*b5)/144)*3.84)*1.3,0))

#### Mcullin

Finally got it. I appreciate the help, it was invaluble.

=IF(ROUNDUP(C4*B5/144,0)<10,(ROUNDUP(C4*B5/144,0)*3.84+10)*1.3,(ROUNDUP(C4*B5/144,0)*3.84*1.3))

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.