Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
New version of OpenOffice available
 
#2
Nice.

Question... is there a spreadsheet function for handling subranges better than nested if statements?

Say I have a value X, and I want to return 1 if x < y, 2 if y < x < z, 3 if z < x < q, etc.
--
Sucrose Octanitrate.
Proof positive that with sufficient motivation, you can make anything explode.
Reply


Messages In This Thread
New version of OpenOffice available - by robkelk - 02-15-2010, 01:41 AM
[No subject] - by ECSNorway - 02-15-2010, 02:17 AM
[No subject] - by Sofaspud - 02-15-2010, 02:45 AM
[No subject] - by robkelk - 02-15-2010, 03:53 AM
[No subject] - by ECSNorway - 02-15-2010, 05:33 AM
[No subject] - by Wiregeek - 02-15-2010, 12:40 PM
[No subject] - by Sofaspud - 02-16-2010, 02:08 AM
[No subject] - by ECSNorway - 02-16-2010, 07:16 AM
[No subject] - by paladindythe - 02-19-2010, 08:00 AM
[No subject] - by ECSNorway - 02-19-2010, 04:47 PM
[No subject] - by Ankhani - 02-19-2010, 10:05 PM
[No subject] - by Sofaspud - 02-20-2010, 12:31 AM
[No subject] - by ECSNorway - 02-20-2010, 09:26 AM
[No subject] - by Sofaspud - 02-20-2010, 09:51 AM
[No subject] - by ECSNorway - 02-20-2010, 10:06 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)