| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between blank and zero ....
I have a worksheet in which a formula calculates the fee based on the item price
in an adjacent cell and a lookup table which shows "breakpoints" in the fee structure. This works fine with any amount (including 0) in item price, but fails when the price cell is blank. When blank, the function MIN(price,75) gives a value of 75 rather than 0. Is this behaviour to be expected? If so, is there an elegant way to handle cells with a blank value, as having "0.00" all over the sheet is a bit untidy? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Skipping blank cells when calculating time difference | Excel Discussion (Misc queries) | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
| Telling the difference between zero and blank in IF statement | Excel Worksheet Functions | |||
Threaded Mode
