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