Apply third formula after two anotner formula

Closed
Banti - 25 Feb 2011 à 09:34
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Mar 2011 à 09:30
Dear sir, when I applied formula in Col-D, I got #value!. I shall be much obliged if any one solve my issue. I tried this
Col-A Col-B Col-C Col-D
-1267 =IF(A1<0,A1,"") =IF(A1>,0,"") =B1+C1 we got #value!
6557
-366
46


Please guide

Banti
Related:

3 responses

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
25 Feb 2011 à 10:21
Hi Banti,

You are using "" in your formula's. For excel that is text and you can't add text to a number. So simply replace "" by 0 to get the desired result.

Best regards,
Trowa
Thanks Trowa, Sorry but there is also an unsolved issue, When I open excel a message comes C:\programme file..........could not be found, check the spelling of.............
Actually I had run an exe file perhaps containing any virus and delete it. I use Office 2010.
Please solve the issue.

with regards,
Banti
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
1 Mar 2011 à 09:30
Sorry Banti, don't know much about that. Sounds to me like you should try reinstalling excel, but there might be better solution.
Since this is off topic you may be better off creating a new topic.

Best regards,
Trowa