Excel formula
oops!
Meant to write MIN
=MIN(5000,(C9*1000))*1.75
--
Regards
Roger Govier
Roger Govier wrote:
Hi Kyle
=MAX(5000,(C9*1000))*1.75
--
Regards
Roger Govier
Kyle P. wrote:
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
|