Yeah, on the one I posted it is missing one... but I have tried many many many many many many- well, you get the point- veriations of the code including the extra parenthesis, more commas, less commas, more spaces, less spaces, more... I don't want to bore you all.
I just don't know what I am doing wrong. I have both sides working of the formula, just not together. Grazie, if you have any other suggestions, they are more than welcome. This has me stumped! I have been scavenging the net looking for formulas or tutorials or helps- anything that might be helpful, but I don't really know what to search for exactly as I don't know how to name what I am trying to do. I have searched "combining formulas", "combining IF formulas" etc with excel in there and so far, I got nothing.

Thanks

j razz

=IF(ISBLANK(E7),"",EOMONTH(E7,0), IF(L6="Class Member",E7+14," "))

If condition:
=IF(ISBLANK(E7)

if true:
""

if false:
EOMONTH(E7,0)

and then extraneous stuff that doesn't make sense to the if statement:
, IF(L6="Class Member",E7+14," ")


How about this way:

=IF(ISBLANK(E7),"", IF(L6="Class Member",E7+14,EOMONTH(E7,0)))

jetdv,

Is there a way to make the "extraneous stuff" make sense for what I am trying to do as mentioned above?
Basically:
The first part needs to remain regardless, unless there is a better way.

If condition
If L6="Class Member" note: this is selected from a drop down box containing class member, non class member, settlement member.

If true
E7+14 note: 14 needs to be added to the total in E7

If false
"" note: do nothing.

How can I add that to the first part of the formula? Or is there some other approach I need to take? Maybe add an "AND" statement in there?
thanks

j razz

Love to help, but got nothing but error messages when trying to download your spreadsheet example at

http://www.southwestcsa.com/ToDoList and select DropDown.xls

If you can email the thing to me, or post it at a working link, I'm sure I can figure it out.

Thanks John,

The address is http://www.southwestcsa.com/ToDoList

and then select "DropDown.xls"

Still having no luck on it.

j razz

=IF(ISBLANK(E7),"",IF(L6="Class Member",E7+14,IF(L6="Non Class Member",E7+7,IF(L6="Settlement Agreement Members",E7+21,"")))

I think I got it with this- I was putting the nested IF's in the wrong place so the logic was wrong. This works, I just need to make it work for EOMONTH formulas and I am set. Still though, if someone knows a better way- please post!

Thanks Grazie, jetdv, johnmeyer

j razz

I just got your email and opened the spreadsheet. Fortunately I read your last post before I started. I'm doing a spreadsheet with similar formulas:

=IF(OR(D37="+",AND(B37="p",OR(AND(B36="c",B35="c"),B36="u"))),"0","1")

that I'm using to parse each frame of video from my film to video transfer unit. I think I finally have that working.

Did I just land on the far side of the rainbow? I thought this was a forum of people using that "other" side of the brain. You guys never cease to amaze me- what a melting pot! I'm impressed.

You know, I went back to check the excel forum that I posted that original message in and still no one replied. I know this forum is for Video (if I didn't by now, you would have to wonder about me :) but I think it just goes to show the quality of the people on this forum and their willingness to help. I just had to take a break for a while and sit back down and look it over again- but what a great feeling to know that people are willing and glad to help when you need it.

j razz

There really is an amazingly broad range of talent and perspectives here.

BTW, if you ever owned an HP programmable calculator, especially the early ones from the 1970s, I wrote an Excel program that lets you quickly and automatically create documentation for your program. Even if you don't own the calculator, I think you'll find some of the programming interesting, given what I saw in your spreadsheet. It's posted at the HP Calculator Museum:



Right click on this to save it to your computer. If you don't have an HP-67 (and who does?), you have to get the valid codes to enter by looking in the Code Table worksheet.

I still have the HP-67 the staff gave me when I left HP in 1976. Absolutely amazing product.