Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Round in an IF statement
Where does the Round go in the following formula:
=IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19)) I want it to round to the nearest 1,000. |
#2
|
|||
|
|||
=IF($C$19<5000000,500000,IF($C$195000000,round(D5 2/$D$95)*$C$19))
******************* ~Anne Troy www.OfficeArticles.com "heater" wrote in message ... Where does the Round go in the following formula: =IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19)) I want it to round to the nearest 1,000. |
#3
|
|||
|
|||
Ooops!!
=IF($C$19<5000000,500000,IF($C$195000000,round((D 52/$D$95)*$C$19),-3))) ******************* ~Anne Troy www.OfficeArticles.com "heater" wrote in message ... Where does the Round go in the following formula: =IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19)) I want it to round to the nearest 1,000. |
#4
|
|||
|
|||
It actually is
=IF($C$19<5000000,500000,IF($C$195000000,ROUND((D 52/$D$95)*$C$19,-3))) Thanks for the direction. "Anne Troy" wrote: Ooops!! =IF($C$19<5000000,500000,IF($C$195000000,round((D 52/$D$95)*$C$19),-3))) ******************* ~Anne Troy www.OfficeArticles.com "heater" wrote in message ... Where does the Round go in the following formula: =IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19)) I want it to round to the nearest 1,000. |
#5
|
|||
|
|||
"heater" wrote in message
... Where does the Round go in the following formula: =IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19)) I want it to round to the nearest 1,000. Divide by 1000, round, then multiply by 1000. -- Peter Aitken Remove the crap from my email address before using. |
#6
|
|||
|
|||
heater wrote:
Where does the Round go in the following formula: =IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19)) I want it to round to the nearest 1,000. You got your answer, and there is nothing wrong with it. But I'm curious .... Why not simply round the IF() result? That is: = ROUND(IF(..., ..., ...), -3) Probably easier for someone else to read. It does not matter that 500000 is already rounded to the desired degree. The only time that would not work for you is if you do not want the result of one of the clauses to be rounded. I think that would be unusual. For example: =IF(..., 543210, ROUND(..., -3)) PS: Are you sure you wrote the nested IF() functions as you intended for your purposes? They result in the word "FALSE" when $C$19 is 500000, but it results in 500000 when $C$19 is less than 500000. Seems a bit odd. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round a number in nested function | Excel Worksheet Functions | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |