| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change formula based upon value of a different cell
In cell E2, I would like a formula which will generate a "Y" if the item in
cell C2 is taxable, and a "N" if the item in cell C2 is not taxable . The items that are not taxable in cell C2 is either "EVERGREEN", "METRO", "RAILPOOL", or "SEACASTLE"; all other items are taxable. Then, if there is a "Y" in E2, the formula in F2 would be "=(A2+B2)*1.07" If there is "N" in E2, the formula in F2 would be just "=(A2+B2)" Thanks for any assistance... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the color of a cell based upon whats in the cell | Excel Discussion (Misc queries) | |||
| Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
| How do I change color pattern based upon a formula within a cell? | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
| Change cell in formula based on date | Excel Discussion (Misc queries) | |||
![Steve[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
