Compare and get result

[americanpie3]

Hi everyone,

Here's what I would like to accomplish

The result is in cell B18

If K18 is greater than D18 by 50 to 99 B18 shows 3
If K18 is greater than D18 by 100 to 149 B18 shows 6
If K18 is greater than D18 by 150 to 199 B18 shows 9

And so on. I tried with IF but doesn't seem to work.

Thanks

 

[PaddyD]

=int((k18-d18)/50)*3

 

[americanpie3]

Thanks

K18=605
D18=518

Your formula works

When I reverse D18-K18 I get a -3 result.

I don't want a negative result and I wonder why a negative result shows up

 

[Brian from Maui]

Try,

=ABS(INT((K18-D18)/50)*3)

Aloha Paddy!