Function Difficulty

  • Thread starter Thread starter Johnnie
  • Start date Start date
J

Johnnie

I am having a problem retrieving information from one worksheet to another.
This is the formula I am using:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,'[Revenue_Projection.xls]Dollar Forecast'!G5+H5,"")

I have also tried it this way:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,sum('[Revenue_Projection.xls]Dollar Forecast'!G5:H5),"")

I have confirmed that F1 and J4 match. Can you please advise me on why I am
not getting the information as requested.

Thanks for your help.

Johnnie
 
There is nothing wrong - it works for me
Try making formula using pointing method rather than typing:
1) Type =IF(F1=
2) Now click on the cell J4 in the second file
3) Type a comma and click on G5 in the second file (forget about H5 for the
moment)
4) complete the formula by typing
Does this work?
best wishes
 
Hi,

Replace your formula with this:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,SUM('[Revenue_Projection.xls]Dollar Forecast'!G5:H5,""))
 
hi
do F1 and J4 contail decimal values??? if so...rounded to what?
your fomula works on my pc but i'm using hard numbers ie no decimals.
Regards
FSt1
 
Bernard,
Thanks for the reply. Must be something screwy with my spreadsheets because
this did not work either. However, it is all irrelevant. I was making the
formula to complicated. F1 & J1 are dates and in the end they are not needed
as the required information is dependent on the dates. Sorry for the extra
work.
Johnnie



Bernard Liengme said:
There is nothing wrong - it works for me
Try making formula using pointing method rather than typing:
1) Type =IF(F1=
2) Now click on the cell J4 in the second file
3) Type a comma and click on G5 in the second file (forget about H5 for the
moment)
4) complete the formula by typing
Does this work?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Johnnie said:
I am having a problem retrieving information from one worksheet to another.
This is the formula I am using:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,'[Revenue_Projection.xls]Dollar Forecast'!G5+H5,"")

I have also tried it this way:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,sum('[Revenue_Projection.xls]Dollar Forecast'!G5:H5),"")

I have confirmed that F1 and J4 match. Can you please advise me on why I
am
not getting the information as requested.

Thanks for your help.

Johnnie
Click to expand...
Click to expand...
 
Shane,
Thanks for the reply. In the end, I was making the formula too complicated.
F1 & J1 are dates and they are not needed as the required information is not
dependent on the dates. Sorry for the extra work.
Johnnie

ShaneDevenshire said:
Hi,

Replace your formula with this:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,SUM('[Revenue_Projection.xls]Dollar Forecast'!G5:H5,""))


--
Thanks,
Shane Devenshire


Johnnie said:
I am having a problem retrieving information from one worksheet to another.
This is the formula I am using:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,'[Revenue_Projection.xls]Dollar Forecast'!G5+H5,"")

I have also tried it this way:

=IF(F1='[Revenue_Projection.xls]Dollar
Forecast'!J4,sum('[Revenue_Projection.xls]Dollar Forecast'!G5:H5),"")

I have confirmed that F1 and J4 match. Can you please advise me on why I am
not getting the information as requested.

Thanks for your help.

Johnnie
Click to expand...
Click to expand...
 

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

problem with formulas (2) 7
problem with formula 6
Help !!! 2
running total between two dates 3
How to concatenate text into a formula? 5
Comparing worksheets & input data 2
Referencing the values returned by a formula 3
=TODAY() and HLOOKUP - help needed 2

Back
Top