=IF(A1="orange",48,"")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"MO" wrote:

I would like to create a forumula that says if "orange" is in a column A,
then put "48" in column B.