Example 1: Customer pre-pays for 5 bulk hours, customer used 16.75 hours, the answer should be 11.75. This is what i'm using =IF(B3<=5,(B3),(B3-C3))
B3 (Bulk Hours) is 16.75 - C3 (Pre-Paid Bulk Hours) is 5 - D3 (Overage Bulk Hours)should be 11.75.
Example 2: Customer pre-pays for 5 bulk...