Replies

Try this:

=IF(E38>=2500,”Capital”,IF(AND(E38=0),”Expense”,”entered negative number”))

–cat

I thought I could use a custom number format ( format | cells | number tab | customer )t
to ensure that what is typed in the cell is actually an email address (with the @ sign and the “dot with 3 characters after it).
I don’t think I can use Data Validation for this.

Any other suggestions … ?
–cat

Thanks for the info. Fortunately, we will not be using the resource capability in MS Project. And, unfortunately, I will probably be maintaining this.
–cat

Thanks for the info. Fortunately, we will not be using the resource capability in MS Project. And, unfortunately, I will probably be maintaining this.
–cat

Thanks, Steve, … that’s exactly what I needed!!!
Cindy

Thanks, Steve, … that’s exactly what I needed!!!
Cindy

Thanks, … I apologize … sometimes I just can’t seem to say what I mean!
–cat

Thanks, … I apologize … sometimes I just can’t seem to say what I mean!
–cat

Thanks, Steve, this works great. My users were complaining that it took so long to “navigate” around. Turning off calculation improves this. And, it still saves with all the formulas calculated! Perfect!
Cindy

Thanks, Steve, this works great. My users were complaining that it took so long to “navigate” around. Turning off calculation improves this. And, it still saves with all the formulas calculated! Perfect!
Cindy

You are the Best, Steve !!! Now, I can proceed!
Thanks,
Cindy

You are the Best, Steve !!! Now, I can proceed!
Thanks,
Cindy

Thanks! This works great for viewing which dates are actual and which ones are still formulas. In order for the rest of my application to work I need to have the count of the formulas (or not formulas) in order to perform some other calculation.

I tried using this formula in the last cell of the row
=countif(A7:Q7,isformula)

but it doesn’t work. Please, do you have any other ideas.
–Cindy

Thanks! This works great for viewing which dates are actual and which ones are still formulas. In order for the rest of my application to work I need to have the count of the formulas (or not formulas) in order to perform some other calculation.

I tried using this formula in the last cell of the row
=countif(A7:Q7,isformula)

but it doesn’t work. Please, do you have any other ideas.
–Cindy

… please ignore my last post. ISFORMULA is what I will be adding as VB code (sorry, for my ignorance, I’m self-taught with macros)
–cat