Thread: excel peeps
View Single Post
Old Jul 27, 2007 | 08:01 AM
  #6  
Tark's Avatar
Tark
Senior Member
 
Joined: Jun 2004
Posts: 30,331
Likes: 0
From: Montréal, Canada
Default
Originally Posted by rebeld
i'm workin on excel formulas now myself ... i hate them :wtc:

heres what i'm doing :

=IF(M5/E5>=0.5,"10",IF(AND(M5/E5>=0.4,M5/E5<0.5),"8",IF(AND(M5/E5>=0.3,M5/E5<0.4),"6",IF(AND(M5/E5>=0.2,M5/E5<0.3),"4",IF(AND(M5/E5>=0.1,M5/E5,0.2),"2",IF(AND(M5/E5>=0,M5/E5,0.1),"1",IF(M5=0,"0")))))))
see IF-AND i find them easy for some reason. My question is a stupid 1 it's not even a formula it's just how do i do that h:
Reply
0