Apply third formula after two anotner formulaClosed

Question

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

TrowaD · Answer

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

Banti · Answer

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 · Answer

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

Apply third formula after two anotner formula

3 responses

Similar discussions

Subscribe To Our Newsletter!