Help with formula please.

[Lee Davison]

Hi,
I have the following formula set up on a sheet called 'Wow'

=IF(Wow!A1="90 / 63 reducer", Wow!B1)


What I would like to add (in plain speak) is if on Wow sheet, cell A1 says
90 / 75 reducer, enter B1 into sheet 4 cell A4.

At the end of the day, what im after is the following:

If on Wow sheet, cell A1 says '90 / 75 reducer', enter Wow sheet B1 figure
into sheet 4 cell A20,
but if on Wow sheet, cell A1 says 'sleeve', enter B1 figure into sheet 4
cell A50,
but if on Wow sheet, cell A1 says 'outlet', enter B1 figure into sheet 4
cell A100.

I hope this makes sense! Also is there a limit to how many 'buts' I could
have in the formula?
Thanks all
Lee

 

[Fredrik Wahlgren]

Hi,
I have the following formula set up on a sheet called 'Wow'

=IF(Wow!A1="90 / 63 reducer", Wow!B1)


What I would like to add (in plain speak) is if on Wow sheet, cell A1 says
90 / 75 reducer, enter B1 into sheet 4 cell A4.

At the end of the day, what im after is the following:

If on Wow sheet, cell A1 says '90 / 75 reducer', enter Wow sheet B1 figure
into sheet 4 cell A20,
but if on Wow sheet, cell A1 says 'sleeve', enter B1 figure into sheet 4
cell A50,
but if on Wow sheet, cell A1 says 'outlet', enter B1 figure into sheet 4
cell A100.

I hope this makes sense! Also is there a limit to how many 'buts' I could
have in the formula?
Thanks all
Lee

I think I understand the essentials. However, you can't enter a value into
another cell from a worksheet function. What you need to use is the
Worksheet_Change event. Google this word.

/Fredrik

 

[JE McGimpsey]

Functions can't put values in cells other than their calling cell. So on
sheet 4:

A20: =IF(Wow!A1="90 / 75 reducer", Wow!B1, "")
A50: =IF(Wow!A1="sleeve", Wow!B1, "")
A100: =IF(Wow!A1="outlet", Wow!B1, "")