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
|