Show text massege when formula result is true

[Papin]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[PCLIVE]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[PCLIVE]

Good point Sandy! The theory was good though

--

 

[Reitanos]

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.

 

[Reitanos]

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.