LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to determine the value - 23 Dec?

Does anyone have any suggestions on how to determine the value?
There is a value 144 in cell A1,
There is a value 10 in cell B1,
I input 140 in cell C1, as 144 = 140 = 134 (144-10), then it return 144 in
cell D1.
I input 150 in cell C1, as 150 = 144, then it return 154 (144+10) in cell D1.
I input 160 in cell C1, as 160 = 144, then it return 164 (144+10*2) in cell
D1.
I input 170 in cell C1, as 170 = 144, then it return 174 (144+10*3) in cell
D1.

I input 130 in cell C1, as 134 (144-10) = 130, then it return 134 in cell D1.
I input 120 in cell C1, as 124 (144-10*2) = 120, then it return 124 in cell
D1.
I input 110 in cell C1, as 114 (144-10*3) = 110, then it return 114 in cell
D1.
I input 100 in cell C1, as 104 (144-10*4) = 100, then it return 104 in cell
D1.

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
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
How to determine the value? Eric Excel Worksheet Functions 2 November 11th 08 01:12 AM
How to determine the value? Eric Excel Worksheet Functions 8 November 10th 08 02:51 PM
How to determine the value? Eric Excel Discussion (Misc queries) 3 March 12th 08 04:09 AM
How to determine the value? Eric Excel Discussion (Misc queries) 8 December 27th 07 05:21 PM
How to determine the value? Eric Excel Discussion (Misc queries) 1 July 24th 07 07:14 AM


All times are GMT +1. The time now is 11:06 PM.

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"