Thread
:
Applying BODMAS to $P23/7*$X23+$Q23
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
external usenet poster
Posts: 10,593
Applying BODMAS to $P23/7*$X23+$Q23
You don't say what order you want the formula to be evaluated.
Give some examples.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"BODMAS application" <BODMAS
wrote in
message ...
I have a certain knowledge of BODMAS and I am attempting to apply it to a
formula created with Excel. The results I receive are incorrect.
The formula applied is:
=IF(AND($N23="No",$V23="N/A",$W230),($P23/7*$X23)+$Q23,($P23-($P23*15%))/7*$X23+$Q23)
Being specific to a column I am calculating, $P23=305 $X23=7 $Q23=50
Obviously, I am aware, in this instance, that 350/7*7=350 but I am
catering
for different inputs, i.e., 350/7*4
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips