| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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..... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Need to Return to Zero
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..... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Need to Return to Zero
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..... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Need to Return to Zero
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..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
Linear Mode
