Formula or Format Error??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.15)+(X13*0.85))))

Cheers
David
 
If the result of this:

SUM(V13*0.15)+(X13*0.85)

Is an integer and the cell is formatted as PERCENTAGE then that will happen.

Try this:

=IF(OR(V13="",X13="",V13="N",X13="R"),"",SUM(V13*0.15,X13*0.85)/100)

Biff
 
Thanks Biff

Biff said:
If the result of this:

SUM(V13*0.15)+(X13*0.85)

Is an integer and the cell is formatted as PERCENTAGE then that will happen.

Try this:

=IF(OR(V13="",X13="",V13="N",X13="R"),"",SUM(V13*0.15,X13*0.85)/100)

Biff
Click to expand...
 
Back
Top