| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need one cell to populate another cell with a $ amount
I have a spread sheet for a dr's office one cell has the dates of service
which i have divided by semi colons for example 5;20;29 each date of service should populate the next cell $25.00 so that should populate the next cell to be $ 75.00. Any help is appreciated! Thanks so much I am really needing this today! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need one cell to populate another cell with a $ amount
I'm not sure if this is what you are saying, but say you have the data
you mention in cell A1. The following formula in cell B1 determines how many ";"s there are, adds 1, then multiplies by 25. If that is now what you want, just let me know. =IF(ISBLANK(A1),0,LEN(A1)-LEN(SUBSTITUTE(A1,";",""))+1)*25 Mark Crissy Hanger wrote: I have a spread sheet for a dr's office one cell has the dates of service which i have divided by semi colons for example 5;20;29 each date of service should populate the next cell $25.00 so that should populate the next cell to be $ 75.00. Any help is appreciated! Thanks so much I am really needing this today! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need one cell to populate another cell with a $ amount
The date of service is in column D and the charge is in column E the chareg
should have a dollar sign and be in dollar format. Thanks so much you are a life saver when you post the formula then do I copy and paste that in the formula bar? Thanks again MARK! "Mark Driscol" wrote: I'm not sure if this is what you are saying, but say you have the data you mention in cell A1. The following formula in cell B1 determines how many ";"s there are, adds 1, then multiplies by 25. If that is now what you want, just let me know. =IF(ISBLANK(A1),0,LEN(A1)-LEN(SUBSTITUTE(A1,";",""))+1)*25 Mark Crissy Hanger wrote: I have a spread sheet for a dr's office one cell has the dates of service which i have divided by semi colons for example 5;20;29 each date of service should populate the next cell $25.00 so that should populate the next cell to be $ 75.00. Any help is appreciated! Thanks so much I am really needing this today! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need one cell to populate another cell with a $ amount
Yes, cut and paste it into the formula bar while you have cell in E. You
need to make a couple of changes and you can edit right in the formula bar. All the references to A1 need to be changed to D1. Also, if the first row with your data is other than row 1, change the number; i.e. if your entries start in row 2, then you'd be pasting into E2 and the A1's should all be D2 "Crissy Hanger" wrote: The date of service is in column D and the charge is in column E the chareg should have a dollar sign and be in dollar format. Thanks so much you are a life saver when you post the formula then do I copy and paste that in the formula bar? Thanks again MARK! "Mark Driscol" wrote: I'm not sure if this is what you are saying, but say you have the data you mention in cell A1. The following formula in cell B1 determines how many ";"s there are, adds 1, then multiplies by 25. If that is now what you want, just let me know. =IF(ISBLANK(A1),0,LEN(A1)-LEN(SUBSTITUTE(A1,";",""))+1)*25 Mark Crissy Hanger wrote: I have a spread sheet for a dr's office one cell has the dates of service which i have divided by semi colons for example 5;20;29 each date of service should populate the next cell $25.00 so that should populate the next cell to be $ 75.00. Any help is appreciated! Thanks so much I am really needing this today! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CALCULATE GST AMOUNT FROM AMOUNT IN OTHER CELL | Excel Worksheet Functions | |||
| How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
Linear Mode
