IF Formul

I need find a formul: Enter IF statement where an additional $ 165 (cell B18)
is added to the price if the ad is in color. Otherwise, the remains the
amount displayed in cell G5.

How do you tell if the ad is in colour? If it is a cell containing the word
the this should help. I assume the word "color" is in A1.

=if(A1="color",G5+B18,G5)

--
Ian
--
"This is a homework" <This is a homework @discussions.microsoft.com> wrote
in message news:[email protected]...
>I need find a formul: Enter IF statement where an additional $ 165 (cell
>B18)
> is added to the price if the ad is in color. Otherwise, the remains the
> amount displayed in cell G5.