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

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

You may wish to tell us what answer you are getting (for whichever state of
the IF test you're looking at), and what you think the correct answer is?

Merely saying "the results ... are incorrect" requires a clairvoyant
capability which is beyond at least some readers of the newsgroup.

If I had to make a wild guess, I would wonder whether the 305 you've talked
about in P23 might be intended to be related in some way to the 350 you talk
about in your example? Is one or other a transcription error?
--
David Biddulph

"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

Bob, thank you for your reply to my question. I will be providing you with
the details you asked for but, I'm afraid it may be at least a week before I
get back to you.

Thank you, again,

Noel Devlin

"Bob Phillips" wrote:

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