Using a cell w/Alpha numeric characters in mulplication formula
Trying to create multple rows with each showing
[14.3 hrs @ $185/hr] (each row different hours and $rate) It's necessary for us to have the brackets showing, but a cell with [14.3 in it is not recognized as a number - same thing applies to the $185/hr Appreciate any assist |
Using a cell w/Alpha numeric characters in mulplication formula
Here's a couple formulas to extract the hours and dollars from your data.
=VALUE(MID(A16,2,FIND(" ",A16)-2)) =VALUE(MID(A16,FIND("$",A16)+1,FIND("/",A16)-FIND("$",A16)-1)) Is that something you can work with? HTH, Elkar "MAJ0116" wrote: Trying to create multple rows with each showing [14.3 hrs @ $185/hr] (each row different hours and $rate) It's necessary for us to have the brackets showing, but a cell with [14.3 in it is not recognized as a number - same thing applies to the $185/hr Appreciate any assist |
Using a cell w/Alpha numeric characters in mulplication formula
With 14.3 in A1 and 185 in B1 enter in C1
=TEXT("["&A1&" hrs @ "&B1,"$##.00")&" /hr]" Gord Dibben MS Excel MVP On Fri, 9 Feb 2007 14:01:00 -0800, MAJ0116 wrote: Trying to create multple rows with each showing [14.3 hrs @ $185/hr] (each row different hours and $rate) It's necessary for us to have the brackets showing, but a cell with [14.3 in it is not recognized as a number - same thing applies to the $185/hr Appreciate any assist |
Using a cell w/Alpha numeric characters in mulplication formula
Gord Dibben <gorddibbATshawDOTca wrote...
With 14.3 in A1 and 185 in B1 enter in C1 =TEXT("["&A1&" hrs @ "&B1,"$##.00")&" /hr]" .... This returns [14.3 hrs @ 185 /hr] but so would ="["&A1&" hrs @ "&B1&" /hr]" and closer to the OP's specs, ="["&A1&" hrs @ "&B1&"/hr]" Why bother with the TEXT call? |
Using a cell w/Alpha numeric characters in mulplication formula
"Harlan Grove" wrote...
.... and closer to the OP's specs, ="["&A1&" hrs @ "&B1&"/hr]" .... Make that ="["&A1&" hrs @ $"&B1&"/hr]" |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com