Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mgilbertson
- Content: Threads
- Order by date
-
Excel 1st Integer 0 Drop
I have the following formula to turn a decimal number into feet-inches-16ths. My only problem is I would like to have the leading zero not appear if it is only inches-16th. Formula: =IF(SIGN(D3)=-1,"- ","")&INT(ROUND(ABS(D3)*16,0)/16/12)&"'-"&TEXT((MOD(ROUND(ABS(D3)*16,0)/16,12)),"#...- mgilbertson
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Excel - IF statement with 1 of 3 possible outcomes
I need some assistance in completing a formula. I am trying to write a formula that must show 1 of 2 results. See example: Cell B16: 10 Cell L16: $0.30 Cell M16: $1.30 Cell Q16 must give one of the following results (b16*0.32) if M16=0, or (b16*0.32)+1 if M16>0, or 0 if neither is true. Here...- mgilbertson
- Thread
- Replies: 14
- Forum: Microsoft: Office
