| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas dollars and formula %
Hello
Excel 2002 - involves 2 columns Column K and column J If the value in K4 = 5 then whatever is in cell J4 in dollars But if the value in K4 =1 then J4 €“ 100 in % Example Column J Column K Results should be 5 1375 $1,375 1 22 78% Thanks in advance I've have tried ..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to round values from formulas to whole dollars | Excel Discussion (Misc queries) | |||
| convert dollars to pounds using a lookup formula | Excel Worksheet Functions | |||
| what is the formula from british pounds to American dollars | Excel Worksheet Functions | |||
| I wish to make a formula that adds dollars in 1 column if a date . | Excel Worksheet Functions | |||
| converting #dollars into word dollars? | Excel Worksheet Functions | |||
Threaded Mode
