if value equals whole number then ...
=if(int(a1)=a1,....
or
=if(int(formula1)=formula1,formula2,formula3)
bd wrote:
I need to write a conditional statement that does the following:
If the result of <formula = a whole number, then <formula2, else <formula3
I have all the formulas working I just don't know how to writeup that first
condition, if the resulting value of the formula is a whole number then do
this, else that.
Pls help, thanks.
--
Dave Peterson
|