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.

IF Formul
 

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