View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BSantos
 
Posts: n/a
Default nesting another formula

=MAX(IF(AND(V16=0,U16=0),S16,IF(N16U16,0,U16-N16)))

I have this formula in cell W6. What I want to do is add to this formula
that what ever the answer is MROUND by 4. I don't know where to put it in the
formula.

Also, if the first formula is true v16 & u16 are ZERO and it brings be s16
then I want it to also take s16*75% and mround that to 4 as well. Because my
answer in this cell must be divisable by 4.

I hope that made sense! Thanks for any help!