View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DavidB DavidB is offline
external usenet poster
 
Posts: 41
Default Formula or Format Error??

Can anyone tell me please why this formula is returning a 4 figure % in my
destination cell Q13 even though I have cleared the cell to "No Decimal
Places":
=IF(OR(V13="",
X13=""),"",IF(V13="N","",IF(X13="R","",SUM(V13*0.1 5)+(X13*0.85))))

Cheers
David