| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need help with unit formulas
When you type an E for each which would equal 1, or type C for per hundred
which would equal .01, how do you get the cell to show E or C but calculate by 1 or .01? |
|
#2
|
|||
|
|||
|
=IF(B2="E",1*A2,0.01*A2)
Provided column A is a number to be multiplied by "E" or "C" I hope this helps. "Tom Andrews" wrote: When you type an E for each which would equal 1, or type C for per hundred which would equal .01, how do you get the cell to show E or C but calculate by 1 or .01? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas not working | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
| Tricky formulas needed | Excel Worksheet Functions | |||
Linear Mode
