Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Applying formats to graphs | Excel Worksheet Functions | |||
Applying data to a spreadsheet..help please | Excel Worksheet Functions | |||
Applying Offset to Range in VBA | Excel Worksheet Functions | |||
applying formula | Excel Discussion (Misc queries) | |||
Applying an AutoFilter to a string | Excel Discussion (Misc queries) |