Consider the following worksheet. The customer demand for any product can either be less than or greater than the amount on hand. If it is less than, there will be some left over. If it is greater than, there will be a shortage. $($If demand equals the amount on hand, there won't be any leftover or shortage.$)$ The values shown in the worksheet illustrate the logic, but the values in rows $7$ and $8$ should recalculate correctly for any values in rows $4$ and $5.$ To generate the values in rows $7$ and $8,$ you could do which of the following?

a$.$ Enter the formulas $=$MAX$($B$4-$B$5,0)$ and $=$MAX$($B$5-$B$4,0)$ in cells B$7$ and B$8,$ and copy them across.

b$.$ Enter the formulas $=$MAX$($B$4,-$B$5,0)$ and $=$MAX$($B$5,-$B$4,0)$ in cells B$7$ and B$8,$ and copy them across.

c$.$ Enter the formulas $=$MIN$($B$4-$B$5,0)$ and $=$MIN$($B$5-$B$4,0)$ in cells B$7$ and B$8,$ and copy them across.

d$.$ None of these choices will work. You need to use IF functions.