We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel Code went Wrong?
Cotta
Posts: 3,667 Forumite
in Techie Stuff
Hi All
M11 = 3.00
N11 = 35.00
K11 = 46.00
The following code returns 376% instead of 83%, does anyone know what has went wrong? I've used the OR statement to remove "#DIV/0!" error messages when the cell contains a "0".
=IF(OR(K11=0),"No Files Audited",(M11+N11/K11))
Thanks in advance.
M11 = 3.00
N11 = 35.00
K11 = 46.00
The following code returns 376% instead of 83%, does anyone know what has went wrong? I've used the OR statement to remove "#DIV/0!" error messages when the cell contains a "0".
=IF(OR(K11=0),"No Files Audited",(M11+N11/K11))
Thanks in advance.
0
Comments
-
N11/K11 takes precedence over M11+N11. So ...
=IF(OR(K11=0),"No Files Audited",(M11+N11)/K11)0 -
Excellent, problem solved and very promptly by yourself - thanks very much.0
-
BODMAS rule (also known as PEDMAS, PEMDAS, BIDMAS, BIMDAS etc...)
Brackets 1st
Order (to the power of) 2nd
Division or multiplication 3rd
Addition or subtraction 4th
That's the order of operations in arithmetic. If there's more than one of any of a single type of the above operations in a sum, they're solved in a left to right order.What will your verse be?
R.I.P Robin Williams.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards