Thread: formula help
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default formula help

Your suggestion had mismatched ()'s.
=ceiling(b12*$N$9)+b12,3)

(I'm not sure how that message got generated, though <vbg.)



Ron Rosenfeld wrote:

On Thu, 2 Apr 2009 14:14:10 -0700, Silverline
wrote:

Excel tells me that $n$9 has to few of arguments. ???
--
glen


You are misreading something.

$N$9 is a cell reference, and cell references cannot have "to few of
arguments".

A function could have too few arguments, but you should be able to read HELP
for that function to figure it out.

If not, please be more complete and accurate in your descriptions of what you
are doing and what is happening.
--ron


--

Dave Peterson