round with a range

[keiserc]

I have a calculated field already rounded to the nearest whole dollar in excel.

now want to round it another level
IF less than $100 - no action
IF $101-250 round up to nearest 4 or 9
IF over $250 round up to the nearest 9

how to do this with formulas, no vb. I'm a simple user. thank you.

 

[DreamerZ]

You can nest the If statements and play around with the Round functions (Round, RoundUp, RoundDown) in the If=true section. Here's an example:

=IF(A1<100,"less than 100",IF(A1<250,ROUNDUP(A1,0),IF(A1>250,ROUNDUP(A1,0),)))

The above would round the numbers up to the next whole number. For example, if A1=142.50 then the Function above would return 143.

Hope that helps.



DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]