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.