Good point Sandy! The theory was good though :-)

--

"Sandy Mann" wrote in message
...
="You are at " & (A1/B1*100)& "%."

For to work wouldn't B1 have to be 3333.3333 for 3%, 5000 for 6% and
6666.66667 for 9%?

I would also suggest:

="You are at " & TEXT(A1/B1,"#%")

to prevent numerous digits being returned from the division.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"PCLIVE" wrote in message
...
Why not just give an exact percentage?
With A1 as your current progress out of the overall process (figure in
B1):

="You are at " & (A1/B1*100)& "%."

Does that help?
Paul

--

"Papin" wrote in message
...
Can i use the if function with the cell function?
--
if cell a1 = 100 then " Your are close to 3%"
if cell a1 = 300 then " Your are close to 6%"
if cell a1 = 600 then " Your are close to 9%"

text masseges
" Your are close to 3%"
" Your are close to 6%"
" Your are close to 9%"

thanks

Excel Rocks