I have asked for help and got answear but it was not what I was looking for. My question is: Lets say I have in cell B1 calculation (SUM A1:A10) that would give me a number if data is typed in data range and #N/A if data is not available. What I wanted to do is to type in cell C1 the formula that would say "if cell B1 is #N/A then type in cell D1 same (#N/A) but if B1 is number then leave D1 empty. Also I don't want D1 to contain any formulas because I want to be able to type in that cell.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Please Help Excel formula!
- Thread starter xsubzeroz
- Start date
- Status
Similar threads
