Show text massege when formula result is true
 

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

Show text massege when formula result is true
 

If you mean exactly those figures thentry:

=IF(A1=100,"You are close to 3%",IF(A1=300,"You are close to
6%",IF(A1=600,"You are close to 6%","Other answer")))

--
HTH

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


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


"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

Show text massege when formula result is true
 

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

Show text massege when formula result is true
 

="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

Show text massege when formula result is true
 

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

Show text massege when formula result is true
 

Sure. You can either nest a few IFs or use math to make the % show up
properly. I'm having a problem with your example numbers because if
100 is 3% it would mean that 300 is 9%.

I think your formula might look like this (and not need the IF at all)
with the changes I made to your numbers:
="You are close to "&TRUNC(A1/33,0)&"%"

If the numbers cannot be calculated directly, you could use a LOOKUP
instead of the division.

On May 29, 3:16 pm, Papin wrote:
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

Show text massege when formula result is true
 

Excuse me if this post is a dupe, because it didn't seem to show up
after the first attempt.

You can either nest a few IFs or use math to make the % show up
properly. I'm having a problem with your example numbers because if
100 is 3% it would mean that 300 is 9%.

I think your formula might look like this (and not need the IF at all)
with the changes I made to your numbers:
="You are close to "&TRUNC(A1/33,0)&"%"

If the numbers cannot be calculated directly, you could use a LOOKUP
instead of the division.

On May 29, 3:16 pm, Papin wrote:
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