I'm using MS XL 2000
App.Range("AQ2").Formula = "=IF(AT2 = 500,MROUND(AI2,500),IF(AT2 =
5,MROUND(AI2,5),IF(AT2=10,MROU*ND(AI2,10),IF(AT2 =
25,MROUND(AI2,25),IF(AT2 = 100,MROUND(AI2,100),IF(AT2 =
200,MROUND(AI2,200),IF(AT2 =
364,MROUND(AI2,364),ROUNDDOWN(*AI2,0))))))))"
App.Range("AQ2:AQ" + Total).FillDown
'where TOTAL = record count of a query
I get #Name? in the cells that I want to be calculated.
My formula doesn't fill correctly. I've tried switching the automatic
and manual and iteration and calculate before saving and they do not
work. I've also tried formatting the number. Any ideas?
Reply
keepITcool Aug 11, 11:28 am show options
Newsgroups: microsoft.public.excel.programming
From: "keepITcool" - Find messages by this
author
Date: Thu, 11 Aug 2005 08:28:46 -0700
Local: Thurs, Aug 11 2005 11:28 am
Subject: Only a genius can help with this 7 Nested If that doesn't
fill down
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
shorten that to:
=IF(ISERROR(MATCH(AT2,{0;5;10;*25;100;200;364},0)) ,
ROUNDDOWN(AI2,0),MROUND(AI2,AT*2))
Also note that MROUND is a function from
the Analysis Toolpak . (hence the NAME error?)
If that is a problem: try Floor or Ceiling instead.
but beware they dont like negative amounts.
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
CondtllyFrmttd wrote :
- Hide quoted text -
- Show quoted text -
"=IF(AT2 = 500,MROUND(AI2,500),IF(AT2 =
5,MROUND(AI2,5),IF(AT2=10,MROU*ND(AI2,10),IF(AT2 =
25,MROUND(AI2,25),IF(AT2 = 100,MROUND(AI2,100),IF(AT2 =
200,MROUND(AI2,200),IF(AT2 =
364,MROUND(AI2,364),ROUNDDOWN(*AI2,0))))))))"
Reply
CondtllyFrmttd Aug 11, 1:10 pm show options
Newsgroups: microsoft.public.excel.programming
From: "CondtllyFrmttd" - Find messages
by this author
Date: 11 Aug 2005 10:10:37 -0700
Local: Thurs, Aug 11 2005 1:10 pm
Subject: Only a genius can help with this 7 Nested If that doesn't
fill down
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Both my formula and yours work. THe only catch is that I have to
manually put my cursor in the actual formula and hit enter. Why the
hell does it do this??!?!?!?!?!? I still get #Name?
Reply