View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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