Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
I am trying to get the word "Successful" in a cell (B32) if another cell(B31)
results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
If the first paragraph you say the range is 92 - 95%. In the second
paragraph you say the range is 92 - 94%. Here's my best guess at what you want... The range is greater than or equal to 92% but less than 95%. =IF(AND(B31=92%,B31<95%),"Successful","") -- Biff Microsoft Excel MVP "rubenwm" wrote in message ... I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
=IF(AND(b3192,b31<95),"Successful","")
-- Russell Dawson Excel Student "rubenwm" wrote: I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
Forgot to say
Please try not to use upper case and exclamation marks when posting questions. I know you are probably trying to demonstrate your frustration and you did give a smiley but your problem will more than likely be ignored when appearing like this. There are many people viewing these postings and they will be looked at and replied to as and when a solution can be found. Most of these people are much more able than me but I am using this forum to educate myself by reading solutions of others and trying to find my own wherever possible. The problem for me is that the others are much faster than me! I don't mean to lecture, sorry. Anyway, it makes the list look UNTIDY!!!! :) Cheers -- Russell Dawson Excel Student "Russell Dawson" wrote: =IF(AND(b3192,b31<95),"Successful","") -- Russell Dawson Excel Student "rubenwm" wrote: I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
Hi Rusell,
First, thanks for helping me with the formula. Second, I agree with you. Sorry. Didn't mean anything by using caps. Thanks again. Ruben "Russell Dawson" wrote: Forgot to say Please try not to use upper case and exclamation marks when posting questions. I know you are probably trying to demonstrate your frustration and you did give a smiley but your problem will more than likely be ignored when appearing like this. There are many people viewing these postings and they will be looked at and replied to as and when a solution can be found. Most of these people are much more able than me but I am using this forum to educate myself by reading solutions of others and trying to find my own wherever possible. The problem for me is that the others are much faster than me! I don't mean to lecture, sorry. Anyway, it makes the list look UNTIDY!!!! :) Cheers -- Russell Dawson Excel Student "Russell Dawson" wrote: =IF(AND(b3192,b31<95),"Successful","") -- Russell Dawson Excel Student "rubenwm" wrote: I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
Thanks Biff.
"T. Valko" wrote: If the first paragraph you say the range is 92 - 95%. In the second paragraph you say the range is 92 - 94%. Here's my best guess at what you want... The range is greater than or equal to 92% but less than 95%. =IF(AND(B31=92%,B31<95%),"Successful","") -- Biff Microsoft Excel MVP "rubenwm" wrote in message ... I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! . |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
Solved.
Thanks Rusell and Biff for your help. "rubenwm" wrote: I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!! :)
You're welcome!
-- Biff Microsoft Excel MVP "rubenwm" wrote in message ... Thanks Biff. "T. Valko" wrote: If the first paragraph you say the range is 92 - 95%. In the second paragraph you say the range is 92 - 94%. Here's my best guess at what you want... The range is greater than or equal to 92% but less than 95%. =IF(AND(B31=92%,B31<95%),"Successful","") -- Biff Microsoft Excel MVP "rubenwm" wrote in message ... I am trying to get the word "Successful" in a cell (B32) if another cell(B31) results/number fall between two percentages of less than 95% and more than 92%. I want B32 to show the word "Successful" if B31 results in a score between 92% and 94%. I guess the 94% must consider 94.9999999 Need ASAP. Thanks!! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|