How to?
Rebecca
You may need to explain a little more about your problem. I doubt whether
the price of Cookies is the only entry here.
If it is then
=IF(B4="cookies",1,"")
in C4 where cookies are $1.
You don't say how much they are. It would be better to have the price in
another part of the worksheet say d4 so the formula would be
-if(b4="cookies",D4,"")
The double quotes leaves the cell blank when b4 does not contain cookies.
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
"Rebecca" wrote:
I have a work sheet that has lots of prices from things that we do and I am
wanting to put it into a page where if say B4 is Cookies then the price for
Cookies automatically pops up in C4, but I dont know how to go about doing
this. Please help. Excel 2007
|