Need help on how I can transfer the formula to another worksheet
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$337.4 $AP$448.4 $AP$564.2 $AP$693.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$337.4 $T$448.4 $T$564.2 $T$693.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?
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 meterAq21 = Water usage57.12 $AP$337.4 $AP$448.4 $AP$564.2 $AP$693.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$337.4 $T$448.4 $T$564.2 $T$693.6 $T$7but it gives this errorCan 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? Read More