A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Reload this Page Formula Help IF?
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formula Help IF?


« Previous Thread | Next Thread »

 
 
Thread Tools Display Modes
  #1  
Old September 21st, 2004, 01:33 PM
~Natasha~
external usenet poster
  
Posts: n/a
Default Formula Help IF?

I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7 nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9


--
~Natasha~
------------------------------------------------------------------------
~Natasha~'s Profile: http://www.excelforum.com/member.php...o&userid=14572
View this thread: http://www.excelforum.com/showthread...hreadid=261973
  #2  
Old September 21st, 2004, 02:03 PM
Frank Kabel
external usenet poster
  
Posts: n/a
Default
Hi
1. Create a separate table on a separate sheet which acts
as lookup table:
A B
1 0 0
2 8 1
3 23 2
....

Now use the following formula:
=VLOOKUP(A1,'lookup_sheet'!A1:B100,2,1)

-----Original Message-----

I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF
(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7
nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9


--
~Natasha~
----------------------------------------------------------
--------------
~Natasha~'s Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14572
View this thread:
http://www.excelforum.com/showthread...hreadid=261973

.
  #3  
Old September 21st, 2004, 02:08 PM
Govind
external usenet poster
  
Posts: n/a
Default
Hi,

Arrange your criteria like this .

column C column D

0 0
8 1
23 2
38 3

and so on.....

Then lets say you have your number in cell A1, use this formula in cell B1

=VLOOKUP(A1,C1100,2,TRUE)

Regards

Govind.


~Natasha~ wrote:
I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7 nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9
  #4  
Old September 21st, 2004, 02:29 PM
Arvi Laanemets
external usenet poster
  
Posts: n/a
Default
Hi

=IF(AND(A1=0,A1=142),(A17)+(A122)+(A137)+(A1 52)+(A167)+(A182)+(A197
)+(A1112)+(A1127)+(A1142),"")



--
Arvi Laanemets
(When sending e-mail, use address arvilAttarkon.ee)



"~Natasha~" wrote in message
...

I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7 nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9


--
~Natasha~
------------------------------------------------------------------------
~Natasha~'s Profile:
http://www.excelforum.com/member.php...o&userid=14572
View this thread: http://www.excelforum.com/showthread...hreadid=261973
  #5  
Old September 21st, 2004, 02:34 PM
Ron Rosenfeld
external usenet poster
  
Posts: n/a
Default
On Tue, 21 Sep 2004 07:33:01 -0500, ~Natasha~
wrote:


I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7 nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9

Assuming your numbers are integers since you have left undefined what you want
for a number like 7.5, then, although I'm sure there's a mathematical
relationship you could use, a lookup function is easiest to implement:

=IF(AND(A1=0,A1=142),HLOOKUP(A1,
{0,8,23,38,53,68,83,98,113,128;0,1,2,3,4,5,6,7,8,9 },2),
"out of range")

The array constants in the above formula can be replaced by ranges, with the
numbers in the ranges.


--ron
  #6  
Old September 21st, 2004, 02:41 PM
Jack Schitt
external usenet poster
  
Posts: n/a
Default
=(A1127)+(A1112)+(A197)+(A182)+(A167)+(A152) +(A137)+(A122)+(A17)

HTH

"~Natasha~" wrote in message
...

I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7 nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9


--
~Natasha~
------------------------------------------------------------------------
~Natasha~'s Profile:
http://www.excelforum.com/member.php...o&userid=14572
View this thread: http://www.excelforum.com/showthread...hreadid=261973
  #7  
Old September 21st, 2004, 03:36 PM
Jack Schitt
external usenet poster
  
Posts: n/a
Default
Oops, I see Arvi posted more or less my solution. But mine has error,
should be


=(A1127)+(A1112)+(A197)+(A182)+(A167)+(A152) +(A137)+(A122)+(A17)-9*
(A1142)


"Jack Schitt" wrote in message
...
=(A1127)+(A1112)+(A197)+(A182)+(A167)+(A152) +(A137)+(A122)+(A17)

HTH

"~Natasha~" wrote in message
...

I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7 nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9


--
~Natasha~
------------------------------------------------------------------------
~Natasha~'s Profile:
http://www.excelforum.com/member.php...o&userid=14572
View this thread:
http://www.excelforum.com/showthread...hreadid=261973
  #8  
Old September 22nd, 2004, 04:44 PM
Dana DeLouis
external usenet poster
  
Posts: n/a
Default
Would this work for you?

=INT((7+A1)/15)

HTH
Dana DeLouis


"~Natasha~" wrote in message
...

I am in need of some help.

I tried this: =IF(A1=0,"0",IF(A1=1,"0",IF(A1=15,"1",""))) I only know
basics so I am running up into a problem once I pass 7 nested items.


Any help would be greatly appreciated.

any number between 00-07 = 0
any number between 08-22 = 1
any number between 23-37 = 2
any number between 38-52 = 3
any number between 53-67 = 4
any number between 68-82 = 5
any number between 83-97 = 6
any number between 98-112 = 7
any number between 113-127 = 8
any number between 128-142 = 9


--
~Natasha~
------------------------------------------------------------------------
~Natasha~'s Profile:
http://www.excelforum.com/member.php...o&userid=14572
View this thread: http://www.excelforum.com/showthread...hreadid=261973
 



« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a SUMPRODUCT formula to COUNTA active... BeSmart Worksheet Functions 8 March 27th, 2004 03:36 PM
Alternative formula to HLookup Bernie Deitrick Worksheet Functions 0 March 26th, 2004 12:53 PM
Offset formula Frank Kabel Worksheet Functions 5 March 15th, 2004 09:50 PM
Dynamic formula to sum across rows turtleman2 Worksheet Functions 5 March 8th, 2004 08:11 PM
Sheet Names Joseph M. Yonek Worksheet Functions 6 January 3rd, 2004 02:15 AM


All times are GMT +1. The time now is 05:19 PM.

Feed Icon - Contact Us - OfficeFrustration excel & word help home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.