Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with formula please.
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 |
#2
|
|||
|
|||
"Lee Davison" wrote in message ... 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 |
#3
|
|||
|
|||
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, "") In article , "Lee Davison" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |