View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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