• 100% Satisfaction Guarantee
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

# =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: 10 months ago.
Category: Microsoft Office
Expert:  Pete replied 10 months ago.

Hello,

Customer: replied 9 months 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 9 months ago.
I don't understand how this "paperclip" works...? I simply used the "Add files" below.
Expert:  Jess M. replied 9 months 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