| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Help with condition
I have two columns that I am dividing one column by the other, yet one column
does not match the same amount of numbers. So when this comes up I would like it to come up with "0" instead of an "error". In actually I am dividing a number by 0. Any help thanks in advance.. |
|
#2
|
|||
|
|||
|
One way:
Rather than =A1/B1 use =IF(B1<0,A1/B1,0) In article , "Mike Busch" wrote: I have two columns that I am dividing one column by the other, yet one column does not match the same amount of numbers. So when this comes up I would like it to come up with "0" instead of an "error". In actually I am dividing a number by 0. Any help thanks in advance.. |
|
#3
|
|||
|
|||
|
Something like:
=IF(ISERROR(A1/B1),0,A1/B1) should do it. The error will still be there, but it will display as a 0. tj "Mike Busch" wrote: I have two columns that I am dividing one column by the other, yet one column does not match the same amount of numbers. So when this comes up I would like it to come up with "0" instead of an "error". In actually I am dividing a number by 0. Any help thanks in advance.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| How to add cells wiht the condition of the former cell. | Excel Discussion (Misc queries) | |||
| Workbook startup condition | Excel Discussion (Misc queries) | |||
| how do i plot this kind of data using excel | Excel Discussion (Misc queries) | |||
| condition format for surrounding cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
