View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kidcasey13
 
Posts: n/a
Default .0 is creating #VALUE! Error

I am currently using the following formula:

=(H21*60)-IF(MID(H21,FIND(".",H21,1),5)0,(MID(H21,FIND(".", H21,1),5)*60),"")+(MID(H21,FIND(".",H21,1),5))

However, I get the results of #VALUE!

In cell H21, the value is 27.00

How do I force excel to recognize the .00 in the formula?

Thanks,
Ryan