LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
G G is offline
external usenet poster
 
Posts: 52
Default Simple Math Question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple Math ? Steve B Excel Discussion (Misc queries) 6 January 7th 09 05:59 PM
Simple Math acss Excel Worksheet Functions 9 June 25th 08 07:02 PM
simple math formula Gabriel Excel Discussion (Misc queries) 3 August 25th 06 03:25 PM
simple math equation Richard Excel Discussion (Misc queries) 8 February 18th 06 08:42 PM
Need help, simple math...from a percentage cfiser Excel Discussion (Misc queries) 2 November 17th 05 04:50 PM


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"