Calculation Question

[Guest]

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 "/"?

 

[Guest]

mstubble

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

Mike Rogers

 

[Guest]

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

 

[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