Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to reduce the code as much as possible with an IF/THEN statement,
here's what I want to do: Take any number (always less than 120) and get the last digit (only). For example, if I have 35, I want 5. Right now, I'm doing the following IF/THEN statement: C12 = 22 (I want 2) =IF(C12=30, C12 -30, IF(C12 =20, C12-20, IF(C12=10, C12-10, C12))) I don't want to write all the code for 120 ... can anyone help me? Thanks. G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Math ? | Excel Discussion (Misc queries) | |||
Simple Math | Excel Worksheet Functions | |||
simple math formula | Excel Discussion (Misc queries) | |||
simple math equation | Excel Discussion (Misc queries) | |||
Need help, simple math...from a percentage | Excel Discussion (Misc queries) |