| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Value Updated based cell input
I'm trying to update a cell "A1" based on a cell value in "B1":
If cell value in B1 < 5, A1 should be 100 if cell value in B1 is between 5-10, A1 should be 200 if cell value in B1 is between 10-20, A1 should be 300 and so on. How do I write a formula in A1 to make this calculation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatiing based on another cell | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Delete Cell Value Based on Another Cell T or F | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Threaded Mode
