We have an old worksheet created for us and it was pre or early 2000. I want to use another worksheet with an updated file. The problem is even if I changed the values the formula doesn't work it gives me a name error.
The formula is
=IF(AP21=0,0,(MAX(watercharge(AQ21,$AP$3,$AP$4,$AP$5,$AP$6,$AP$7),571.2)))
Ap21 = Current water reading on the meter
Aq21 = Water usage
| 57.12 $AP$3 |
| 37.4 $AP$4 |
| 48.4 $AP$5 |
| 64.2 $AP$6 |
| 93.6 $AP$7 |
Also when I search MAX or watercharge, it directs me back to the formula.
Copy pasting the formula doesn't work to the new worksheet.
I tried changing the values to fit my new worksheet
=IF(O8=0,0,(MAX(watercharge(P8,$T$5,$T$6,$T$7,$T$8,$T$9),384.35)))
| 57.12 $T$3 |
| 37.4 $T$4 |
| 48.4 $T$5 |
| 64.2 $T$6 |
| 93.6 $T$7 |
but it gives this error
Can anyone help/teach me how I could make this work?
I am new to excel any help would be appreciated.
How can I also share my worksheet?
