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

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

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