I have formula in Col J eg J2 gives a value of 219,999. I want this to be rounded so that the last value end with a zero i.e 220,000
I have attached sample data
Your assistance is most appreciated
I have formula in Col J eg J2 gives a value of 219,999. I want this to be rounded so that the last value end with a zero i.e 220,000
I have attached sample data
Your assistance is most appreciated
How about
=ROUND(G2-H2-I2,-1)
Quang PT
Thanks for the help. never thought of using -1 in round function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks