Function Difficulty
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" wrote:
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
|