Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Formulas in same cell
I am having trouble trying to make a formula work.
what I am trying to do is this. I have text in one cell ie Townsville, Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet to take the value from an adjacent cell and *0.44%*50/25. If the value of the cell is Townsville then I need the worksheet to take the value from the adjacent cell and *0.44%*35/25. If the value is anything else I need the worksheet to take the value from the adjacent cell and *0.36%*35/25 Can anyone help me with this delimnar |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Formulas in same cell
"C Anderson" wrote:
.. I have text in one cell ie Townsville, Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet to take the value from an adjacent cell and *0.44%*50/25. If the value of the cell is Townsville then I need the worksheet to take the value from the adjacent cell and *0.44%*35/25. If the value is anything else I need the worksheet to take the value from the adjacent cell and *0.36%*35/25 One way .. Assuming text in A1 down, with adjacent values (to multiply) in B1 down Put in C1, copy down: =IF(A1="","",IF(A1="Townsville",B1*0.44%*35/25,IF(A1="Brisbane",B1*0.44%*50/ 25,B1*0.36%*35/25))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Formulas in same cell
See reply in .Misc
Biff "C Anderson" wrote in message ... I am having trouble trying to make a formula work. what I am trying to do is this. I have text in one cell ie Townsville, Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet to take the value from an adjacent cell and *0.44%*50/25. If the value of the cell is Townsville then I need the worksheet to take the value from the adjacent cell and *0.44%*35/25. If the value is anything else I need the worksheet to take the value from the adjacent cell and *0.36%*35/25 Can anyone help me with this delimnar |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Formulas in same cell
"Biff" wrote:
See reply in .Misc Aha, I told the OP over there to see a response over here <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up multiple logical conditions on one result cell | Excel Worksheet Functions | |||
apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
create multiple formulas in 1 cell | Excel Worksheet Functions | |||
Entering multiple formulas in one cell | Excel Worksheet Functions |