formula

[MO]

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

 

[Dave F]

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

Dave

 

[Gord Dibben]

=IF(A1="orange",48,"not orange") entered in B1


Gord Dibben MS Excel MVP