Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a problem with the mod function...I need to make it conditional on
the related adjacent cell...here's what I have =IF(K2=180,MOD(K2,180)) What I need is if K2 is equal to or greater than 180 then execute the mod function in the appropriate adjacent cell If K2 is less than 180 then do not execute the mode function in the adjacent cell...leave the exiting number , if any, alone The above executes the mod function ok if equal or greater than 180...but if less than 180...it's returning a false statement ? I'm sure this is simple but I can't come up with changes that give the above desired results. Thanks, Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |