EXCEL (IF)

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!

Hi,

This isn't; to me, very clear but maybe this

=CHOOSE(E1,12,57,67,77,87)

Now if e1 is 1 the formula returns 12, If e1=2 it returns 57 etc
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Alicia-Paris" wrote:

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!

It didnt work.

Basically: 1=36, 2=72, 3=108, 4=132, 5=165.

COLUMN E comes from a different worksheet via macros, so i want COLUMN F to
then show the true value between 1-5 to the numbers shown above.

i.e.

e3= 4............... therefore i want f3= 132

"Mike H" wrote:

Hi,

This isn't; to me, very clear but maybe this

=CHOOSE(E1,12,57,67,77,87)

Now if e1 is 1 the formula returns 12, If e1=2 it returns 57 etc
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Alicia-Paris" wrote:

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!

Try

=IF(E1,CHOOSE(E1,12,57,67,77,87),"")

--
Jacob (MVP - Excel)


"Alicia-Paris" wrote:

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!

Also, i forgot to add.... the COLUMN E cells already have something in them..
they are hyperlinked to another workbook. i.e. the number in them is from
another sheet. i have just put in the cell : =(cell from other workbook)

"Alicia-Paris" wrote:

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!

THANKS, BUT DIDNT WRK NEITHER

"Jacob Skaria" wrote:

Try

=IF(E1,CHOOSE(E1,12,57,67,77,87),"")

--
Jacob (MVP - Excel)


"Alicia-Paris" wrote:

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!

Mike has mentioned which function to be used. Check out help on CHOOSE() and
modify the values to suit.

Incase the cell in E1 do not have a value; the formula will return an
error., You can handle that using the IF() statement mentioned in the
previous formula....

--
Jacob (MVP - Excel)


"Alicia-Paris" wrote:

THANKS, BUT DIDNT WRK NEITHER

"Jacob Skaria" wrote:

Try

=IF(E1,CHOOSE(E1,12,57,67,77,87),"")

--
Jacob (MVP - Excel)


"Alicia-Paris" wrote:

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!

unless i miss something important Column F is always 36 x column E

so in your example:

put "=36*E3" in F3 and copy down

If you got the example wrong (the text says 'true value between 1-5') then
the formula might be "=36/E3"

hth
RegMigrant

"Alicia-Paris" wrote:

It didnt work.

Basically: 1=36, 2=72, 3=108, 4=132, 5=165.

COLUMN E comes from a different worksheet via macros, so i want COLUMN F to
then show the true value between 1-5 to the numbers shown above.

i.e.

e3= 4............... therefore i want f3= 132

"Mike H" wrote:

Hi,

This isn't; to me, very clear but maybe this

=CHOOSE(E1,12,57,67,77,87)

Now if e1 is 1 the formula returns 12, If e1=2 it returns 57 etc
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Alicia-Paris" wrote:

COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to
depend on the E COLUMN. But I am not sure how to do this.

The IF function doesnt work because I want there to be 5 conditions.

Basically.... 1= one number 2= a different number 3= a diff number and so
on; and with this, depending on which number gets put in cell E (1-5), i want
F to reflect the true number.

Please help guys as this is driving me bonkers!