Calculation Question

M

mstubble

Is it possible to do the following:

In a cell have $4.00/4 and have a formula that will take the value before
the "/" and divide by the value after the "/"?
 
M

Mike Rogers

mstubble

If you make the dollar sign be there via cell formating then =4.00/4 should
do it.

Mike Rogers
 
M

mstubble

I should have clarified. $4.00/4 is in on cell and I want the result to
appear in the next cell.
 
T

T. Valko

Try this:

A1 = $4.00/4

=IF(COUNTIF(A1,"*/*"),LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,255),"")

Format as CURRENCY 2 decimal places

Result = $1.00
 
Top