formatting a cell

  • Thread starter Thread starter Lise
  • Start date Start date
L

Lise

I've set up a timesheet for our office and was wondering
is there a way to reference:

In cell B5 to B7 I have a drop down list for IE $10, DC
$5, FU $5 in which they have to choose which $ amount. I
have it set up for 5 days a week and then say in cell c5 I
want it to add the totals but cannot set the formula
because there is Text infront of the $ amount. Is there a
way to calculate this?
 
Hi

Set up your list without the dollar sign and format the cells as currency
instead.
 
=SUMPRODUCT(MID(B5:B7,FIND("$",B5:B7),255)*1)

HTH
Jason
Atlanta, GA
 
Thanks Jason!

MID is supposed to be IE $10, DC $5, etc? And what is 255?
TIA.

Lise
 
I'm not Jason, but =mid() has 3 arguments.

The first is the string to search, the second is where to start, the last is for
how many characters.

The 255 in Jason's formula says to go 255 characters after you find the $ sign.
(Jason could have used a smaller number, but I bet 255 is pretty darn safe!)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell not calculating after importing data 2
Where to put quotes in a SUMIF formula and when is & used for cell 2
15 minutes early 5
Double Lookup 3
Numbers change in cell even when formatted as text 4
if a cell value changes, update date in another cell. 2
Column sum incorrect upon subtracting 6
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Back
Top