| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percent and dollars in Same Column
Hello
I have column M, in this column there are only 2 numbers either a 5 or a 1 .. Column P has numbers/values. Now if the value in column M is a 5 that means that the value in column P should equal to dollars. If the value in column M is a 1 then the value in column P should equal % e.g Column P = 5 then column O should read $125.10 -Column P = 1 then value in column O = 5% Whatever value is in column P should either be a dollar value or a % value. Is there a formula to automate this ? I have about 300 rows and it is taking forever, and this is a monthly report thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting currency from US Dollar into Canadian dollars from column A to Column B | Excel Worksheet Functions | |||
| How do I sum dollars in one column based on dates in another? | New Users to Excel | |||
| I wish to make a formula that adds dollars in 1 column if a date . | Excel Worksheet Functions | |||
| Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
| converting #dollars into word dollars? | Excel Worksheet Functions | |||
Threaded Mode
