| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a formul | Excel Discussion (Misc queries) | |||
| Is there a good book that would help me learn functions and formul | Excel Worksheet Functions | |||
| formul that add 1.5 day, every end of month | Excel Discussion (Misc queries) | |||
| how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) | |||
| can you use a variable or cell reference in a getpivotdata formul. | Excel Worksheet Functions | |||
Linear Mode
