Prev: Excel
Next: Track Changes without sharing
From: Kyle P. Kyle on 12 Apr 2010 11:00 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
From: Roger Govier on 12 Apr 2010 11:07 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
From: Paul C on 12 Apr 2010 11:20 Use MIN =MIN((C9*1000)*1.75 ,5000*1.75)) Once C9*1000 exceeds 5000 W the 5000*1.75 will be the smaller of the two  If this helps, please remember to click yes. "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
From: Kyle P. on 12 Apr 2010 11:33 Thanks Paul, I hate when I miss a simple, creative way to problem solve! Really shoulda seen that, let's call it inexperience. :) Thanks Again, Kyle Parenzan "Paul C" wrote: > Use MIN > =MIN((C9*1000)*1.75 ,5000*1.75)) > > Once C9*1000 exceeds 5000 W the 5000*1.75 will be the smaller of the two > >  > If this helps, please remember to click yes. > > > "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
From: Roger Govier on 12 Apr 2010 18:23 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

Pages: 1 Prev: Excel Next: Track Changes without sharing 