Function Difficulty

[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

 

[Bernard Liengme]

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

 

[ShaneDevenshire]

Hi,

Replace your formula with this:

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

 

[FSt1]

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

 

[Johnnie]

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

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

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

 

[Johnnie]

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

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

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