Round up a number to nearest 50

[lesley burlingham]

Hi. I have a formula which generates an amount. I need to round this figure up to the nearest £50 is this possible.

=IF(H22+(B28*H22)=0,"No Price available, please contact PMC",H22+(B28*H22))

Thanks

 

[Faseeh]

Do you want round up only round up/round down to nearest 50?

 

[lesley burlingham]

round up always

 

[Faseeh]

Please try ROUNDUP(E15/50,0)*50 where E15 contains a number.

 

[Khalid NGO]

=IF(H22+(B28*H22)=0,"No Price available, please contact PMC",H22+(B28*H22))

Hi,
You can remove multiple calculations by using single formula and custom cell format.

=CEILING(H22+(B28*H22),50)

format your cell as:
#,##0;-#,##0;"No Price available, please contact PMC"

Regards,

 

[NARAYANK991]

Hi ,

There is a lot of information here :

https://support.microsoft.com/en-us/kb/196652

As an aside , this link gives some information on an issue which has been raised in this forum many times :

https://support.microsoft.com/en-us/kb/214118

Narayan