americanpie3
Board Regular
- Joined
- Jul 16, 2003
- Messages
- 187
- Office Version
- 365
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
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