I am trying to set up a spreadsheet to show the costs, after rebates, for a
solar array. They rebate for New York is $1.75 per watt. That would be an
easy formula of: =the number of watts*1.75, or =(C9*1000)*1.75 on my
spreadsheet.

However, they only reimburse a customer up to 5000 watts. what formula can I
use to get excel to properly calculate this cell?

Thanks for any help possible,
Kyle Parenzan