Excel 2003 how to had another OR function to my IF function

[cajodonn]

I have the function: H3 =IF(OR($C3="2011-06",F3=""),"",IF(F3<-0.044,-1,IF(F3>0.044,1,0)))

In the 1st parathesis I want to add another OR function that states if F3 is blank then H3 returns blank, if F3 is not blank then it runs the 2nd parathesis.

Thank you for any help in advance!

[NBVC]

Maybe you want?

=IF($C3<>"2011-06",IF(F3="","",IF(F3<-0.044,-1,IF(F3>0.044,1,0))),"")

[daddylonglegs]

Your quoted formula already returns a blank if F3 is blank, am I missing something?

[cajodonn]

I believe I put in the same as you =IF(OR($C3<>"2011-06",IF(F3="","",IF(F3<-0.044,-1,IF(F3>0.044,1,0))),"") but it says I am missing a parathesis or comma.

Daddylonglegs If it is it is not running I thought in the original formula I posted the first paratehsis means if it is "2011-06" then a blank is posted. Because when I looked through what the formula produced in column H it still posts a value even if there is a blank cell in F. I want it to read if it is "2011-06" in column C OR if it is a blank cell in column F then the value in H should be blank

[daddylonglegs]

I want it to read if it is "2011-06" in column C OR if it is a blank cell in column F then the value in H should be blank

That's what your original version does, perhaps F3 isn't actually blank, is there a formula in that cell.....or could it be another character like a space (which isn't blank but looks like it)?

[cajodonn]

Ah not in the F column but in my other columns that are like the F there is a formula, so I think there is the issue so i am just going to make a new tab and in the new one do copy and paste values I think that should do the trick

---------- Post added at 11:47 AM ---------- Previous post was at 11:37 AM ----------

Nevermind you were exactly right instead of having ,"" for a blank I had ," ". Thanks a lot for the help again Ive been trying to figure this out all morning.