ExcelBanter - formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula (https://www.excelbanter.com/excel-discussion-misc-queries/128963-formula.html)

formula

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

Dave F

formula

=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.

Gord Dibben

formula

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

Gord Dibben MS Excel MVP

On Fri, 2 Feb 2007 10:06:01 -0800, MO wrote:

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

All times are GMT +1. The time now is 03:05 AM.