View Single Post
  #1   Report Post  
obion
 
Posts: n/a
Default probably easy but....


I'm wanting to build an if then statement, and if the value returns true
then return one numeric value, and if it returns false it returns
another numeric value.

the details
what i'm needing is to compare 2 values one will be constant (8) the
other will be a variable. The variable will be divided by the
constant, and if it will divide I want to return the value of 24, but
if it won't I'll want to return the value of 18. Is this possible, and
if so how?

thanks in advance.


--
obion
------------------------------------------------------------------------
obion's Profile: http://www.excelforum.com/member.php...o&userid=27892
View this thread: http://www.excelforum.com/showthread...hreadid=473921