| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
"E" or "O" for the first, even or odd digit in a number
hi there!
I need a formula, to say "E" if the first digit of a four-digit-number in A1 is even. and "O" if its odd. Thanks a lot! |
|
#2
|
|||
|
|||
|
Hi!
Try this: =IF(A1="","",IF(MOD(LEFT(A1,1),2)=0,"E","O")) Biff "jenn" wrote in message ... hi there! I need a formula, to say "E" if the first digit of a four-digit-number in A1 is even. and "O" if its odd. Thanks a lot! |
|
#3
|
|||
|
|||
|
On Thu, 23 Jun 2005 19:53:01 -0700, "jenn"
wrote: hi there! I need a formula, to say "E" if the first digit of a four-digit-number in A1 is even. and "O" if its odd. Thanks a lot! =IF(MOD(INT(A1/1000),2),"O","E") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 16th digit changes?? Problem,16th digit changes to a zero.... | Excel Worksheet Functions | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Linear Mode
