Formula references an answer from another formula.

**dmrose** · 01-31-2012, 09:55 AM

My skill level: Novice
Version: Excel 2007

I have a very simple spreadsheet. I need to figure out the productivity value as specified by the formula given to me. Then the weekly productivity average has to be averaged for the month. I thought I had it figured out but only the formula that I input into the cell shows up where I believe the answer should be. What am I doing incorrectly?

A macro is not really desired for the answer. I believe that there has to be a way to do this all on one sheet.

Thanks in advance.

example-productivity.xlsx

**dmrose** · 01-31-2012, 10:01 AM

Figured out my own answer. Cell formula was fat fingered by me. Should be =IF(ISERROR(J32/J28),"-",J32/J28) and had =IF(ISERROR(J32/J28),"0",J32/J28) instead. Swear I scratched my head for an hour on that. Do not know how many times I swore at that. Sorry.

**Bob Phillips** · 01-31-2012, 10:02 AM

Just select the cell, F2 and Enter.

**TMShucks** · 01-31-2012, 10:03 AM

Well, it looks as though it's formatted as Text, but it's not.

I pressed F2 and Enter and it works, though I don't quite know.

Could be that it's picked up the text attribute from one of the merged cells ... Merged cells are really bad things; avoid if possible.

Regards, TMS

**ww1711** · 01-31-2012, 10:05 AM

If what you're looking for is to NOT display the formula, and to display the results of the formula instead, then this is your answer:

Click the cell (J34);
Either, go click in the formula bar, or press F2 on the keyboard;
Press enter.

Your formula seems to be displaying as text.

If that's not what you're asking, then be a little more clear and I'd be glad to help!

Good luck!

**dmrose** · 01-31-2012, 10:08 AM

Merged so it prints pretty for who its for. (I am a very Jr. SysAdmin who gets asked to do these "simple things", I am not very well versed in Excel but I am pretty good with AD

.) Was given an example hand written sheet and instructed to make it look similar. I figured out it was just a typo in my formula, but now I can not figure out how to mark this thread as solved. I am starting to think it is Monday.

**ww1711** · 01-31-2012, 10:19 AM

Hah, every day is a Monday when you're dealing with Excel issues!

**TMShucks** · 01-31-2012, 11:18 AM

Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save