IF Formul

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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)
 
You must log in or register to reply here.

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
Still stumped 7
Formulate a cell to change color when above/below an amount? 3
How to Spell Number in English? I mean write 1 & see One? 2
If function help 0
References between worksheets using IF 7
HOW TO GET A SUM TO NOT EQUAL A NEGATIVE 3
ISNUMBER 5

Back
Top