| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
The following formula is comming up with a "circular reference error" The
deal is that I need the formula in column D to return the answer if I divide the total of column C by the total of column B, but if column C is "0" then I would like it to to return the answer as "0". =IF(C727=0,0,C727/B727) Can someone please help me rewrite this to avoid the error message? Thank you, Candi C |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Statement
If you want the result to appear in C727, then in C727:
=IF(SUM(C1:C726)=0,0,SUM(C1:C726)/B727) -- Gary''s Student - gsnu200849 "CandiC" wrote: The following formula is comming up with a "circular reference error" The deal is that I need the formula in column D to return the answer if I divide the total of column C by the total of column B, but if column C is "0" then I would like it to to return the answer as "0". =IF(C727=0,0,C727/B727) Can someone please help me rewrite this to avoid the error message? Thank you, Candi C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| If statement or lookup statement not sure | Excel Worksheet Functions | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Linear Mode
