IF A1=BLUE

[weh2oski]

if a1 = Blue c1 should be B1-4
if a1 = green c1 should be B1-8
if a1 = yellow c1 should be B1-11
please help with setup

 

[WillR]

On 2002-10-04 07:08, weh2oski wrote:
if a1 = Blue c1 should be B1-4
if a1 = green c1 should be B1-8
if a1 = yellow c1 should be B1-11
please help with setup

=IF(A1="Blue",B1-4,IF(A1="Green",B1-8,IF(A1="Yellow",B1-11,0)))

this should be placed in cell C1

 

[Aladin Akyurek]

On 2002-10-04 07:08, weh2oski wrote:
if a1 = Blue c1 should be B1-4
if a1 = green c1 should be B1-8
if a1 = yellow c1 should be B1-11
please help with setup

=B1-INDEX({4,8,11},MATCH(A1,{"Blue","Green","Yellow"},0))

 

[Brian from Maui]

I did miss something! It's late!
This message was edited by Brian from Maui on 2002-10-04 07:13

 

[WillR]

On 2002-10-04 07:12, WillR wrote:

On 2002-10-04 07:08, weh2oski wrote:
if a1 = Blue c1 should be B1-4
if a1 = green c1 should be B1-8
if a1 = yellow c1 should be B1-11
please help with setup

=IF(A1="Blue",B1-4,IF(A1="Green",B1-8,IF(A1="Yellow",B1-11,0)))

this should be placed in cell C1

i'm assuming that A1 contains the text values Blue,green or yellow & not actually formatted blue, green or yellow....