Remember Me? March 19th 07, 04:40 PM posted to microsoft.public.excel.worksheet.functions
 BD external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 16 if value equals whole number then ...

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. March 19th 07, 04:47 PM posted to microsoft.public.excel.worksheet.functions
 Pete_UK external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856 if value equals whole number then ...

Assuming <formula is in A1, then try this:

=IF(INT(A1)=A1,<formula2,<formula3))

INT returns the integer portion of A1. Another way would be:

=IF(MOD(A1,1)=0,<formula2,<formula3))

MOD returns the remainder after dividing A1 by 1.

Hope this helps.

Pete

On Mar 19, 4:40 pm, 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. March 19th 07, 04:50 PM posted to microsoft.public.excel.worksheet.functions
 Dave Peterson external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 35,218 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 March 19th 07, 04:55 PM posted to microsoft.public.excel.worksheet.functions
 Pete_UK external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856 if value equals whole number then ...

Sorry,

my penultimate closing brackets should be in both formulae, i.e.:

=IF(INT(A1)=A1,<formula2,<formula3)
=IF(MOD(A1,1)=0,<formula2,<formula3)

Pete

On Mar 19, 4:47 pm, "Pete_UK" wrote:
Assuming <formula is in A1, then try this:

=IF(INT(A1)=A1,<formula2,<formula3))

INT returns the integer portion of A1. Another way would be:

=IF(MOD(A1,1)=0,<formula2,<formula3))

MOD returns the remainder after dividing A1 by 1.

Hope this helps.

Pete

On Mar 19, 4:40 pm, 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.- Hide quoted text -

- Show quoted text -

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post JcR Excel Worksheet Functions 7 March 16th 06 05:10 AM JWDesigns New Users to Excel 3 December 8th 05 05:03 PM Kevin Jones Excel Worksheet Functions 0 October 25th 05 09:23 PM Dave S. Excel Worksheet Functions 3 June 12th 05 10:07 PM plindman Excel Discussion (Misc queries) 1 June 1st 05 11:29 PM

All times are GMT +1. The time now is 04:02 PM. Copyright ©2004-2022 ExcelBanter.