If statement with rounding

[ohlegend]

I am trying to write a statement the rounds the calculated data to 1 if the calculated number is less than 1. If the calculated number is greater than 1, I want the calculated number to be displayed. For Example:

Num 1 = 20
Num 2 = 40

Num 1/Num 2 = .5 ( I want to round up to 1 on this instance)

Num 1 = 80
Num 2 = 40

Num1/Num2 = 2 ( I want to output the 2 in this instance )

Thanks

 

[GorD]

Wrap the whole thing in a MIN(1,if(....................)) statement.

Any value less than 1 wil then calculate as 1

 

[Sektor]

=if(mod(b12,b13)=0;b12/b13,round(b12/b13,1))

 

[Jonmo1]

Welcome to the board...

Try

=MAX(1, Num1/Num2)

Hope that helps.

 

[CharlesChuckieCharles]

=ROUND(Num1/Num2,0) or Jonmo1 's if your examples aren't full enough

 

[Jonmo1]

Wrap the whole thing in a MIN(1,if(....................)) statement.

Any value less than 1 wil then calculate as 1

Max and Min can be a little confusing...You actually want MAX here..

MIN - Returns the SMALLEST of the given numbers
MAX - Returns the LARGEST of the given numbers

 

[ohlegend]

What if I wanted to add a statement that says:

Do the calculations mentioned above, but if there is nothing in cell B4, leave the cell blank?

 

[Jonmo1]

Try

=IF(B4="","",MAX(1, Num1/Num2))