Formula or Format Error??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DavidB - 17 Oct 2006 06:28 GMT

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

Reply to this Message

Biff - 17 Oct 2006 07:13 GMT

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

> 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
[quoted text clipped - 4 lines]
> Cheers
> David

Reply to this Message

DavidB - 17 Oct 2006 07:38 GMT

Thanks Biff

> If the result of this:
>
[quoted text clipped - 16 lines]
> > Cheers
> > David

Reply to this Message

Biff - 17 Oct 2006 08:10 GMT

You're welcome!

Biff

> Thanks Biff
>
[quoted text clipped - 20 lines]
>> > Cheers
>> > David

Reply to this Message