| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divided by zero
Hi All,
I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1 equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0! Plz help Regards Hassan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Divided by zero
=if(iserror(a1/b1),0,a1/b1)
or =if(b1=0,0,a1/b1) -- Regards, Tom Ogilvy "Hassan" wrote: Hi All, I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1 equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0! Plz help Regards Hassan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Divided by zero
=IF(B1=0,0,A1/B1) Hassan wrote: Hi All, I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1 equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0! Plz help Regards Hassan -- Gordon Rainsford London UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value divided by time | Excel Worksheet Functions | |||
| Zero divided by Zero | Excel Programming | |||
| 365-day divided into 13 periods | Excel Discussion (Misc queries) | |||
| returning zero on pct divided by zero | Excel Discussion (Misc queries) | |||
| Amount is divided by 100 | Excel Discussion (Misc queries) | |||
Linear Mode
