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