defining a formula
 

recently I was helped with a formula - where I was needing a value off of
sheet 1 to be placed on sheet 2

the formula that worked: =if(pricing!$c$2=1, pricing!b15,"") this works,
but what I found is in order to make this work, the pricing sheet needs to
show c2 with the 1 value, when I book the same formula for another item, the
c2 will have a different value, therefore the first formula results in a zero
- how can I make it a contant?

c2 in the pricing sheet reflects a chart with many items, I scroll on the
item wanted, and the c2 changes and makes the whole pricing sheet change to
reflect costs for that item - then when I want another item: I scroll the
chart and click - and c2 changes

This is confusing to me as well, I hope someone can read between this comboble
thank you

defining a formula
 

You could try

This will work if the cell is not blank.
=if(pricing!$c$2<"", pricing!b15,"")

This will work if the the cell is greater the Zero
=if(pricing!$c$20, pricing!b15,"")


--
bobwilson
------------------------------------------------------------------------
bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046
View this thread: http://www.excelforum.com/showthread...hreadid=528649