IF Formul

G

Guest

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

Ian

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I formulate total before Gst? 2
Formulate a cell to change color when above/below an amount? 3
Still stumped 7
HOW TO GET A SUM TO NOT EQUAL A NEGATIVE 3
How do I hyperlink to a specific cell in other excel worksheet? 4
References between worksheets using IF 7
ISNUMBER 5
cell formulas 3

Top