If the condition (K2=180) is not true...then I want the function to take no
action...just leave the value in J2 alone ?
can this be done ?


wrote in message
oups.com...
Are you working with two cells or three? Plus, the IF formula below
doesn't have an ELSE condition set. That's where you're getting the
FALSE from. An IF formula has three parts: =IF(TheCondition,
WhatHappensIfTrue, WhatHappensIfFalse). You're missing the last
part. It should look something like:
=IF(K2=180,MOD(K2,18),somethingelse)

Hope that helps!
Cory

On Oct 31, 1:06 pm, "Tim" wrote:
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