Thread: Conditional Formatting Need to Return to Zero

Here is the formula.....=IF(SUM(C7-4000)>6000,6000,SUM(C7-4000)) I know I
should be able to insert another IF statement or perhaps a Max.....

What exactly are you trying to accomplish?

"KB" wrote:

> Here is the formula.....=IF(SUM(C7-4000)>6000,6000,SUM(C7-4000)) I know I
> should be able to insert another IF statement or perhaps a Max.....

Base Rate $5.00
Up to 4k 0.0017 7.48 $0.01
4k to 10K 0.0024 (3,992.52) $(9.58)
Over 10K 0.0025 3,992.52 $9.98
7.48 $5.41
I would like the 4k to 10k to return to zero instead of showing a negative
number

"tim m" wrote:

> What exactly are you trying to accomplish?
>
> "KB" wrote:
>
> > Here is the formula.....=IF(SUM(C7-4000)>6000,6000,SUM(C7-4000)) I know I
> > should be able to insert another IF statement or perhaps a Max.....

Water Rate Analysis

New Reading 54651
Old Reading 54650
Difference 1
Conversion Rate 7.48
Gallons 7.48

NEW RATES
Base Rate $5.00
Up to 4k 0.0017 7.48 $0.01
4k to 10K 0.0024 (3,992.52) $(9.58).....I have used this formula
=IF(SUM(C7-4000)>6000,6000,SUM(C7-4000))
Over 10K 0.0025 3,992.52 $9.98
7.48 $5.41

> I would like the 4k to 10k to return to zero instead of showing a negative
> number
>
> "tim m" wrote:
>
> > What exactly are you trying to accomplish?
> >
> > "KB" wrote:
> >
> > > Here is the formula.....=IF(SUM(C7-4000)>6000,6000,SUM(C7-4000)) I know I
> > > should be able to insert another IF statement or perhaps a Max.....