-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
tying
-
D
If, and or
<tbody> A B 1 10 2 0 3 26 </tbody> A1 = blank (but not empty as it has " ") B1 = number A2 = 0 B2 = empty A3 = 26 B3 = empty I am trying to write IF statement: if A1, A2 etc is a number and =0 OR B1, B2 etc is blank (empty) then delete row. In table above I should have C1...- drluke
- Thread
- blank delete empty number
- Replies: 3
- Forum: Excel Questions
-
A
If statement help **result showing #value!
Hi I'm tying to do this Nested IF statement and I get the error #VALUE ! which I cannot find out why, please could someone help me. Formula =IF(AND(R5>=0.05,R5<=0.0699),-40),IF(AND(R5>=0.07,R5<=0.09),0),IF(AND(R5>=0.0901,R5<=0.012),60),IF(AND(R5>=12.01,R5<=15),120,0) I want my my cell in R5...- andycreber
- Thread
- #value find formula statement
- Replies: 5
- Forum: Excel Questions
-
G
How much data is too much...?
Hello, I am currently contemplating the creation of a Power View sheet using an Access file that I could create housing some 3,000+ PC techs information such as name, location, certifications, etc. and tying it all together. Anyone know how long it would take excel to load something like this...- gdm2481
- Thread
- certifications excel location long
- Replies: 1
- Forum: Power Tools
