Thread: Only a genius can help with this 7 Nested If that doesn't fill down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
  
Posts: 2,253
Default Only a genius can help with this 7 Nested If that doesn't fill down
shorten that to:

=IF(ISERROR(MATCH(AT2,{0;5;10;25;100;200;364},0)),
ROUNDDOWN(AI2,0),MROUND(AI2,AT2))

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 :

"=IF(AT2 = 500,MROUND(AI2,500),IF(AT2 =
5,MROUND(AI2,5),IF(AT2=10,MROUND(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 With QuoteReply With Quote