Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF possible?
Hello, if possible i need the following to display in a cell if the conditions below are met: If between *85 *and *89* inclusive is displayed i need the adjacent cell to display "*R*". If betwen *90 *and *94* inclusive then cell should read "*A*" and, if between *95 *and *100 *displayed then adjacent cell should display "*G*". Btw, the R,A,G, is just a RED , AMBER, GREEN scoring. Cheers. -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555265 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF possible?
Nel post
*fodman* ha scritto: Hello, if possible i need the following to display in a cell if the conditions below are met: If between *85 *and *89* inclusive is displayed i need the adjacent cell to display "*R*". If betwen *90 *and *94* inclusive then cell should read "*A*" and, if between *95 *and *100 *displayed then adjacent cell should display "*G*". Btw, the R,A,G, is just a RED , AMBER, GREEN scoring. Cheers. Hi, try this: =IF(ISNA(LOOKUP(C17,{85,90,95},{"R","A","G"})),"", IF(C17100,"",LOOKUP(C17,{85,90,95},{"R","A","G"}) )) where C17 is the cell to test. If the value in C17 is lower than 85 or higher than 100, the formula result is "" (a null string), i.e. the cell will look empty. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF possible?
hi! why don't u try =IF(AND(A5=85,A5<90),"R",IF(AND(A5=90,A5<=94),"A ",IF(AND(A5=95,A5<=100),"G",""))) -via135 fodman Wrote: Hello, if possible i need the following to display in a cell if the conditions below are met: If between *85 *and *89* inclusive is displayed i need the adjacent cell to display "*R*". If betwen *90 *and *94* inclusive then cell should read "*A*" and, if between *95 *and *100 *displayed then adjacent cell should display "*G*". Btw, the R,A,G, is just a RED , AMBER, GREEN scoring. Cheers. -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=555265 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF possible?
Works perfect, thanks. :) -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555265 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF possible?
Why not use conditional formatting to colour the cells rather than return a
RAG value. You could use 3 conditions with a formula of =AND(A5=85,A5<90 for red =AND(A5=90,A5<=94) for amber =AND(A5=95,A5<=100) for green I have posted an example at http://cjoint.com/?gzl2IQsBJy -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "fodman" wrote in message ... Works perfect, thanks. :) -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555265 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF possible?
Thanks but i need the "R" "A" "G" in the cells as the results get sent to ancient blackberry handhelds so colour formatting doesn't show up.! -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555265 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF possible?
Oh I see. I think I would still colour the RAG column for the Excel version
anyway, added value <g -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "fodman" wrote in message ... Thanks but i need the "R" "A" "G" in the cells as the results get sent to ancient blackberry handhelds so colour formatting doesn't show up.! -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555265 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|