L Laura Lee Day Dec 3, 2008 #1 I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so that the last number is a 9....please help!
I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so that the last number is a 9....please help!
G Glenn Dec 3, 2008 #2 Laura said: I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so that the last number is a 9....please help! Click to expand... =ROUNDUP(A1+0.01,1)-0.01
Laura said: I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so that the last number is a 9....please help! Click to expand... =ROUNDUP(A1+0.01,1)-0.01
R Ron Rosenfeld Dec 3, 2008 #3 On Wed, 3 Dec 2008 09:43:00 -0800, Laura Lee Day <Laura Lee I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so that the last number is a 9....please help! Click to expand... =CEILING(A1+0.01,0.1)-0.01 --ron
On Wed, 3 Dec 2008 09:43:00 -0800, Laura Lee Day <Laura Lee I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so that the last number is a 9....please help! Click to expand... =CEILING(A1+0.01,0.1)-0.01 --ron
