R
RJD
Using this formula and receivin a #N/A error.
According to the function wizard everything is formatted
correctly
According to the function wizard everything is formatted
correctly
F
Frank Kabel
Hi
please post your complete formula
please post your complete formula
N
Norman Harker
Hi RJD!
Only way I can replicate this is if cells that the arguments refer to
are returning #N/A.
Otherwise the errors returned are usually #NAME? (Analysis ToolPak not
installed or selected as an Addin or reference to a non-existent
name), and #NUM! (invalid data inputs). See Help on both of those.
Only way I can replicate this is if cells that the arguments refer to
are returning #N/A.
Otherwise the errors returned are usually #NAME? (Analysis ToolPak not
installed or selected as an Addin or reference to a non-existent
name), and #NUM! (invalid data inputs). See Help on both of those.
B
Beverley
I had this when I was using the drop-down wizard thing to fill it in, but
didn't notice the scroll bar and therefore didn't see the prompt for the
final parameter. Ensure you've *really* got it all filled out -- the last
item is "Type" not "End_Period"
Beverley
didn't notice the scroll bar and therefore didn't see the prompt for the
final parameter. Ensure you've *really* got it all filled out -- the last
item is "Type" not "End_Period"
Beverley