| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Or function with invalid number "zero/zero"
I have created a formula IF(OR(B1=0,A1=0,B1/A1=99.5%),0,B1/A1). If the
value of B1=0, the formula seems to ignore the first 2 criteria and focuses on the 3rd logical portion. I don't understand this since the OR function should return "TRUE" if any of the conditions are met, which in this case is met on the 1st one. Why is this? Note if you remove the 3rd logical scenario of B1/A1 the formula works, so I know without a doubt this is where the problem is, I just can't figure out why or how to get around it. -- Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Roundup or Ceiling Function to round to a specific number | Excel Discussion (Misc queries) | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| a function that counts the number of cells with information | Excel Worksheet Functions | |||
| Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
| Text Function with Different Formatting for Number | Excel Discussion (Misc queries) | |||
Threaded Mode
