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

Formula or Format Error??
 

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" wrote in message
...
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

Formula or Format Error??
 

Thanks Biff

"Biff" wrote:

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" wrote in message
...
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

Formula or Format Error??
 

You're welcome!

Biff

"DavidB" wrote in message
...
Thanks Biff

"Biff" wrote:

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" wrote in message
...
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