How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

=IF(A10,"Positive",))) A 1 0 zero 2 -2 Negative 3 -3

Customer Question

=IF(A10,"Positive",)))
A B
1 0 zero
2 -2 Negative
3 -3 Negative
4 4 Positive
5 1 Positive
6 test Positive
7 zero
Why does the formula above return the B6 ("Positive") and B7 ("zero")??? The formula works fine for the first five (B1 thri B5
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Pete replied 1 year ago.

Hello,

can you please attach the spreadsheet here, using the paperclip icon?

Customer: replied 1 year ago.
The formula in the B column is incorrect above, but the file with the correct formula has been sent this morning (attached) and yesterday. Looking forward to your reply. Thanks
Customer: replied 1 year ago.
I don't understand how this "paperclip" works...? I simply used the "Add files" below.
Expert:  Jess M. replied 1 year ago.

Hi Tommy,

Do you still need help with your attached Excel file?

Please let me know so that I can give you an explanation of your formulas.

Jess

Related Microsoft Office Questions