View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BODMAS application BODMAS application is offline
external usenet poster
 
Posts: 1
Default Applying BODMAS to $P23/7*$X23+$Q23

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