nesting another formula

[BSantos]

=MAX(IF(AND(V16=0,U16=0),S16,IF(N16>U16,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!

 

[intruder9]

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

 

[BSantos]

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

 

[intruder9]

you got it, works OK does it not