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!

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!

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!

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!