Hi Everyone,

I'm new here, and have been taking a course at an online college for management through excel spreadsheets.
One issue I have come across is decreasing one cell based on increases in another.

For example, cell B2 is MPH at 55.6mph. Cell C2 is MPG at 6.5.
I am trying to decrease by X based on every +1 increase of cell B2.

i had used an if(and) function, and was able to subtract once, but can not figure out how to continue the decrease based up B2 increases.

Thanks in advance!!!!!

Patrick