| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement
is there a way to formulate the following.
IF A2 = whole number then enter 0 if A2 contains a decimal than enter content of B4. whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statement
On Thu, 30 Jul 2009 12:14:01 -0700, ironworker
wrote: is there a way to formulate the following. IF A2 = whole number then enter 0 if A2 contains a decimal than enter content of B4. whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect Try this formula: =IF(A2=INT(A2),0,B4) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statement
=IF(MOD(A2,1)=0,0,B4)
-- Kind regards, Niek Otten Microsoft MVP - Excel "ironworker" wrote in message ... is there a way to formulate the following. IF A2 = whole number then enter 0 if A2 contains a decimal than enter content of B4. whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if statement
thank you I was able to uses nieks for my situation
"Niek Otten" wrote: =IF(MOD(A2,1)=0,0,B4) -- Kind regards, Niek Otten Microsoft MVP - Excel "ironworker" wrote in message ... is there a way to formulate the following. IF A2 = whole number then enter 0 if A2 contains a decimal than enter content of B4. whole number = any number without a decimal ie 1, 4 ,6 ,10, 15, ect Decimal = any number with decimal ie 1.11, 4.32, 5.5, 10.6, 33.33, ect |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
