Excel 2010 : avoiding rounding on certain conditions using IF statements 1

[pendle666]

Hello

This spreadsheet contains values for each week, say:

[pre]
A B C D
1 0.00 229.00 79.99 160.00
[/pre]


Other cells contain 10% of the above values. But it rounds C1 to £8.00 but it must be £7.99.

I tried using

[pre]
=IF(K11="79.99","7.99",(K11*10/100))
[/pre]

but it's still giving me 8.00 as the answer.

I'm not sure what to do here, can someone advise?

thanks

thank you for helping

____________
Pendle

 

[SkipVought]

HI,

I have no idea what you're doing.

You post some data related to row 1 columns A, but then your formula is K11????

Numbers then currency???

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[pendle666]

Hi

Sorry K11 is the original cell in my worksheet.


The formula in cell D11 should be

[pre]
=IF(C1="79.99","7.99",(C1*10/100))
[/pre]




thank you for helping

____________
Pendle

 

[SkipVought]

try

=INT(C1*10)/100

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[pendle666]

Yayy that's worked! And so simple!

Thank you - have a star!

thank you for helping

____________
Pendle