IF STATEMENT

JK · 06-27-2006, 01:45 PM

This is what I'm trying to do...

IF
A2 IS EQUAL TO 8 THEN DISPLAY 228.0 IN A3
A2 IS EQUAL TO 10 THEN DISPLAY 182.4 IN A3
A2 IS EQUAL TO 12 THEN DISPLAY 152.0 IN A3
A2 IS EQUAL TO 16 THEN DISPLAY 114.0 IN A3
A2 IS EQUAL TO 20 THEN DISPLAY 91.2 IN A3
A2 IS EQUAL TO 24 THEN DISPLAY 76.0 IN A3

Could someone show me easiest way to do this?
Much appreciated...

**Bearacade** · 06-27-2006, 01:55 PM

You can:

1) Use vlookup

2) Use if:

=IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,"Out of Range"))))))

3) Use lookup:

=LOOKUP(A2, {8,10,12,16,20,24;228,182.4,152,114,91.2,76})

Marcelo · 06-27-2006, 01:55 PM

Hi

=IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,FALSE))))))

HTH
regards from Brazil
Marcelo

"JK" escreveu:

> This is what I'm trying to do...
>
> IF
> A2 IS EQUAL TO 8 THEN DISPLAY 228.0 IN A3
> A2 IS EQUAL TO 10 THEN DISPLAY 182.4 IN A3
> A2 IS EQUAL TO 12 THEN DISPLAY 152.0 IN A3
> A2 IS EQUAL TO 16 THEN DISPLAY 114.0 IN A3
> A2 IS EQUAL TO 20 THEN DISPLAY 91.2 IN A3
> A2 IS EQUAL TO 24 THEN DISPLAY 76.0 IN A3
>
> Could someone show me easiest way to do this?
> Much appreciated...

JK · 06-27-2006, 02:10 PM

THANKS!

"Marcelo" wrote:

> Hi
>
> =IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,FALSE))))))
>
> HTH
> regards from Brazil
> Marcelo
>
> "JK" escreveu:
>
> > This is what I'm trying to do...
> >
> > IF
> > A2 IS EQUAL TO 8 THEN DISPLAY 228.0 IN A3
> > A2 IS EQUAL TO 10 THEN DISPLAY 182.4 IN A3
> > A2 IS EQUAL TO 12 THEN DISPLAY 152.0 IN A3
> > A2 IS EQUAL TO 16 THEN DISPLAY 114.0 IN A3
> > A2 IS EQUAL TO 20 THEN DISPLAY 91.2 IN A3
> > A2 IS EQUAL TO 24 THEN DISPLAY 76.0 IN A3
> >
> > Could someone show me easiest way to do this?
> > Much appreciated...

Marcelo · 06-27-2006, 02:30 PM

thanks for the feedback

"JK" escreveu:

> THANKS!
>
> "Marcelo" wrote:
>
> > Hi
> >
> > =IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16,114,IF(A2=20,91.2,IF(A2=24,76,FALSE))))))
> >
> > HTH
> > regards from Brazil
> > Marcelo
> >
> > "JK" escreveu:
> >
> > > This is what I'm trying to do...
> > >
> > > IF
> > > A2 IS EQUAL TO 8 THEN DISPLAY 228.0 IN A3
> > > A2 IS EQUAL TO 10 THEN DISPLAY 182.4 IN A3
> > > A2 IS EQUAL TO 12 THEN DISPLAY 152.0 IN A3
> > > A2 IS EQUAL TO 16 THEN DISPLAY 114.0 IN A3
> > > A2 IS EQUAL TO 20 THEN DISPLAY 91.2 IN A3
> > > A2 IS EQUAL TO 24 THEN DISPLAY 76.0 IN A3
> > >
> > > Could someone show me easiest way to do this?
> > > Much appreciated...