Question on 'isblank" and 'if" commands working together.

**tek0011** · 09-08-2011, 11:59 AM

I need help trying to figure this spreadsheet out. Here is what I want it to do. I think I have gotten pretty far for being a novice/intermediate with excel.

Looking for some help from you wonderful folks.

Essentially what I need it to do is, if the number in Fx matches the number in Ex or is less then 100 from it, I need "Is this a spare" to be asked.
So far I have figured out how to do that. I was also able to figure out how to use conditional formatting to highlight this if it pops up. Now comes the complicated parts.

- As you see when there is no data (starting on G41), "Is this a spare?" still appears. If there is no data in Fx or Ex I want it to return blank. cant figure out how to incorporate the ISBLANK command along with my other IF statements.

I have three other questions I have on this spreadsheet and will create corresponding threads for them

Thanks.

**NBVC** · 09-08-2011, 12:04 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

Also, if you have multiple complicated questions, then post them each as new threads... waiting first until one is complete so you can carry forward from that thread if necessary.

**tek0011** · 09-08-2011, 12:32 PM

Let me get this straight.. You want 3 separate forum posts? Ill do that, but seems counter productive, especially for a forum where there is already too many posts for a mod to watch.
Let me know and Ill create 3 separate posts for these issues.

**NBVC** · 09-08-2011, 01:09 PM

Why don't you start with one.. and if the next question(s) are directly related you can continue them, else they would need new threads.

The main reason for separate posts is for searching for problems...