| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What if Senario?
I am not sure if I should be using the what if senario or not.
What I am trying to do is if one cell in worsheet #1, lets say b14= 2.375, then I want cell f12 on the same worksheet to equal cell B15 from Worksheel titled Material Costs. Not sure how to do this, I was trying if (B14=2.375,'Material Costs!B15') but it did not work, any suggestions?? -- Donna |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What if Senario?
if (B14=2.375,'Material Costs!B15')
f (B14=2.375,'Material Costs ' !B15 ) -- Don Guillett Microsoft MVP Excel SalesAid Software "Tacklemom" wrote in message ... I am not sure if I should be using the what if senario or not. What I am trying to do is if one cell in worsheet #1, lets say b14= 2.375, then I want cell f12 on the same worksheet to equal cell B15 from Worksheel titled Material Costs. Not sure how to do this, I was trying if (B14=2.375,'Material Costs!B15') but it did not work, any suggestions?? -- Donna |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What if Senario?
Wrong placing of closing single quote.
=if (B14=2.375,'Material Costs'!B15,"whatever you want if condition not met") -- David Biddulph "Tacklemom" wrote in message ... I am not sure if I should be using the what if senario or not. What I am trying to do is if one cell in worsheet #1, lets say b14= 2.375, then I want cell f12 on the same worksheet to equal cell B15 from Worksheel titled Material Costs. Not sure how to do this, I was trying if (B14=2.375,'Material Costs!B15') but it did not work, any suggestions?? -- Donna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Isoloating particular senario from pivot table | Excel Worksheet Functions | |||
| "table of contents" senario | Excel Worksheet Functions | |||
| about senario | New Users to Excel | |||
Linear Mode
