Thread: 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.

Nel post news:fodman.29x83b_1151176803.738@excelforum-nospam.com
*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(C17>100,"",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

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

Originally Posted by fodman

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.

Works perfect, thanks.

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" <fodman.29xaen_1151179803.5626@excelforum-nospam.com> wrote in
message news:fodman.29xaen_1151179803.5626@excelforum-nospam.com...
>
> 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
>

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.!

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" <fodman.29yg2n_1151233805.5779@excelforum-nospam.com> wrote in
message news:fodman.29yg2n_1151233805.5779@excelforum-nospam.com...
>
> 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
>