Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Need help on how I can transfer the formula to another worksheet

Copper Contributor

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

Jopat98_4-1705542912059.pngJopat98_5-1705542955730.pngJopat98_6-1705542984210.png

 


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

Jopat98_3-1705542550379.png

Jopat98_7-1705543102226.png

=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

Jopat98_2-1705541499533.png

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?

 



1 Reply
You can put a copy of your worksheet on OneDrive or GoogleDrive with a link pasted here that grants access to it.