| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show formulas result + text directly | Excel Worksheet Functions | |||
| If formula true result then divided into 2 columns | Excel Worksheet Functions | |||
| Why does the formula show instead of the result? | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| How do I highlight a formula result (IF statment=True) | Excel Worksheet Functions | |||
Hybrid Mode
