Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA HELP
Try something like this:
For a value in A1 B1: =IF(INT(A1)=A1,A1,INT(A1)*12+MOD(A1,1)*100) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "steve" wrote: I have a column of cells with numbers like 5.10, 4.10, and whole integers like 60,65,70,etc. the whole numbers are in inches and the fractions are in feet and inches like 5feet and ten inches. If I want all the numbers to appear in inches format in the next column ,what formula do I apply.That is the values inches should remain as they are and the values in feet should be converted into inches and displayed. The feet measurements are below 9 feet in value. any help in this regard will be appreciated very much. thank you guys and have a nice day steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |