Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |