| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Some Help Needed on getting info out of a cell from a formula
Hi All,
Ok I have created a Workbook using 3 pages Tab1=RPM_Main, Tab2=PPS and Tab3=Laps. I have the info from cells on Tab2 and Tab3 going to Tab1, However on Tab1=RPM_Main in certain cells there is nothing to compute and is given me an error #DIV/0! The Formula I am using is In Column "D" is =SUM(B7/2/C7). Now the Column "C" may have a 0=ZERO brought over from the Tab2 worksheet as there is no data computed and it is giving me the #DIV/0! error. How can I change this formula to do away with that Error? I have some other issues with this Spreadsheet and will discuss each one once I get other issues resolved to help keep my sanity, LOL. Thanks Much In advance. Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i renamed a file i needed and lost the info how do i get it back? | New Users to Excel | |||
| If Info In Cell Then Formula In Another | Excel Discussion (Misc queries) | |||
| Hyperlink info & help needed | Excel Discussion (Misc queries) | |||
| Info needed...please help! | Excel Discussion (Misc queries) | |||
| Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions | |||
Threaded Mode
