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!

nesting another formula
 

Does this work for you
=MAX(IF(AND(V16=0,U16=0),MROUND(S16,4),IF(N16U16, 0,MROUND((U16-N16),4))))


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=502616

nesting another formula
 

Yes, but where could I but s16*75% (should I put it in the MROUND(S16*75%,4)?

"intruder9" wrote:


Does this work for you
=MAX(IF(AND(V16=0,U16=0),MROUND(S16,4),IF(N16U16, 0,MROUND((U16-N16),4))))


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=502616

nesting another formula
 

you got it, works OK does it not.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=502616