My formula Is giving me a #NAME!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello from Steved

If I try the below formula in sheet1
=DOLLARFR(DOLLARDE($O$5,60)-DOLLARDE($N$5,60),60) it works fine but in Sheet2
a get an error #NAME!

=Sheet1!DOLLARFR(DOLLARDE($O$5,60)-DOLLARDE($N$5,60),60)

What do I need to do to correct this please.

Thankyou.
 
Try:

=DOLLARFR(DOLLARDE(Sheet1!$O$5,60)-DOLLARDE(Sheet1!$N$5,60),60)
 
I am not familiar with these functions but
why do you have the Sheet1! in front of the DOLLARFR?
have you tried the equation on sheet 2 without the Sheet1!
Do you need some of the cells to be from Sheet1?
if so try
=DOLLARFR(DOLLARDE(Sheet1!$O$5,60)-DOLLARDE(Sheet1!$N$5,60),60)
 
This may be a second response
I am not familiar with the functions
but Why do you have the Sheet1! in front of the second sheet equation?
if it is the cells you need from sheet1 try
=DOLLARFR(DOLLARDE(Sheet1!$O$5,60)-DOLLARDE(Sheet1!$N$5,60),60)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal Time Subtractions 3
How Do I Avoid #REF! In Formulas? 4
add hyperlink using sheet names and cells(i,j) 3
Modifying A Sumproduct Formula 1
Possible to refer to a sheet's object name ? 1
Sumproduct 5
vlookup returns na 7
Drop Down with dynamic named range offsheet source list 14

Back
Top