Round Problem Help Required

[microhunt]

I am using the following formula

,=IF(OR(D6=""),"",+SUM(2.5*V6)/2.5)

I have formatted to one decimal point. So if the the number was 7.2, I would like to round to 7
Were if the number was 7.3 then I would like to round to 7.5.

Is there a way of modifying my formula to do this?

Appreciate any help?

 

[Joe4]

Welcome to the Board!

The formula is a bit strange, it is doing a bunch of things that aren't necessary:
- It is using "OR", but you only are checking one condition (so there is no reason to use it)
- You are using the SUM function when you aren't actually doing any summing
- You are multiplying and dividing the value in V6 by the same value, which cancels itself out.

So what you have written so far could be simplified to this:

=IF(D6="","",V6)

To round to the nearest half number, just use:

=IF(D6="","",MROUND(V6,0.5))

 

[microhunt]

Welcome to the Board!

The formula is a bit strange, it is doing a bunch of things that aren't necessary:
- It is using "OR", but you only are checking one condition (so there is no reason to use it)
- You are using the SUM function when you aren't actually doing any summing
- You are multiplying and dividing the value in V6 by the same value, which cancels itself out.

So what you have written so far could be simplified to this:

=IF(D6="","",V6)

To round to the nearest half number, just use:

=IF(D6="","",MROUND(V6,0.5))

Thank you for your reply?

This is the formula I am using now

=IF(OR(D5="",E5>3),"NONE",V5

Can you suggest modification for round formula?

 

[microhunt]

I think I got it, thanks

=IF(OR(D5="",E5>3),"NONE",MROUND(V5,0.5))

 

[microhunt]

Thank you ?