Formula or Format Error??

[DavidB]

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

 

[Biff]

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

 

[DavidB]

Thanks Biff

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

 

[Biff]

You're welcome!

Biff

Thanks Biff