EXCEL Help - IF THEN statements

LRC Community/Where to Run/Race Reviews LetsRun.com Community

Moderation Moderation Information Moderation Information & Rules

15 years ago 12/20/2010 8:55am EST

Please help LRC!

This is probably a simple fix, but I'm not too familar with EXCEL.

I have a report, which asks a question (A1) with several follow-up questions (A2:A10) based upon the main question.

If the main answer is not applicable, I have figured out how to display, "N/A" in cell A1. =IF(A1=TRUE,"N/A",SUM(A1:A10)).

Instead of just displaying "N/A" in cell A1, I would like it to be displayed in the series of cells, A1 through A10?

Thanks for any assistance...

15 years ago 12/20/2010 8:58am EST

re: Mikey B

Don't worry about the damn thing, just pay someone to do it for you like this guys did:

http://www.letsrun.com/forum/flat_read.php?thread=3837308

15 years ago 12/20/2010 9:35am EST

re: Mikey B

you need to use conditional formatting.

these steps aren\\\'t completely accurate I don\\\'t have excel open in front of me right now so take it for what its worth

Go to conditional formatting -> new rule -> formatting based on a formula

make sure cells A1:A10 are highlighted and enter your IF statement in the formula box

15 years ago 12/20/2010 1:17pm EST

re: excelerator

Thanks for the reply...

What People Are Talking About On LetsRun

No top threads at the moment. Check back soon.

Reply Replying to

Username

Password

Leave the password field blank to post anonymously.

Post Preview

By posting you acknowledge that you have read and abide by our Terms and Conditions.

Remember me on this device.

Real Runners, Real Reviews

Help us build the best running shoe review site for a chance to win a LetsRun t-shirt. Help us build the best running shoe review site for a chance to win one of 10 LetsRun t-shirts.

What shoe are you reviewing?

Rate your shoe

Overall Rating

Appearance

Comfort

Cushioning

Durability

Value

I would buy this shoe again

Yes No

Would you buy this shoe again?

One-line review. Optional. Your written review provides information to readers that numbers can't.

Email Optional. Required for t-shirt drawing.

Real runner reviews • Community-powered rankings

EXCEL Help - IF THEN statements

This thread has already been deleted.

You have been subscribed.