Question about Microsoft Excel for PC

1 Answer

Replace a cell value with a certain formula if cell value is zero

I want my N cell value replace with d cell value/c value if N cell value is Zero.

Thanks,

Jas

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

TRY THIS

=if (n1=0,d1/c1,n1)

if n1 = 0
than
d/c
else
n1

Posted on Oct 10, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

I get an error when I tally cells that have errors because of dividing empty cell by empty cell.


Hi I dont really have much to do with Excel as I essentially build and repair and install, gosh I still type with two fingers!! Now below I have provided a link to Microsoft . Ways to count values in worksheets etc. If the problem persists try to update Office with what ever sercice packs are required and see if this helps. the link is http://office.microsoft.com/en-au/excel-help/ways-to-count-values-in-a-worksheet-HA010287849.aspx and I do hope it helps.
Cheers

Oct 28, 2011 | Microsoft Excel for PC

2 Answers

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...


Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

3 Answers

NEED TO AVERAGE CELLS, WHERE ONE OR MORE CELLS CONTAIN ''0'' OR ''#D


Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

Aug 26, 2009 | Microsoft Office Excel 2007

1 Answer

Excel Formula


With data in A1 to C1: A2 =IF(A1>0,1,0) B2 =IF(B1>0,1,0) C2 =IF(C1>0,1,0) A3 =SUM(A2:C2)

Jun 04, 2009 | Microsoft Office Excel 2007

2 Answers

FORMULA PROBLEM IN MS EXCEL


The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Apr 18, 2009 | Microsoft Office Excel 2003 for PC

3 Answers

More than 256 characters in a cell in Excel


If a RANGES
\r\n
Named Ranges. SheetLevel Named Range, Named Constants, Named Formulas ,Relative Named Ranges ,Dynamic Named Ranges ,Advanced Dynamic Named Ranges .
\r\nWorking With Ranges. FindLast cell/row/column etc.
\r\nFormula Reference Changer. Absolute to Relative etc.
\r\nSpecialCells Method
\r\nExcel Named Range Manager $
\r\nOFFSET RANGES VBA
\r\nReturns a Range object that represents a range that?s offset from the specified range. Read-only.
\r\nexpression.Offset(RowOffset, ColumnOffset)
\r\n\\"expression\\" is required and should be a Range object.
\r\n
\r\nRowOffset: Optional Variant. The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.
\r\n
\r\nColumnOffset: Optional Variant. The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.
\r\n
\r\nExample
\r\nSub OffsetMe()
\r\n MsgBox Range(\\"B2\\").Offset(RowOffset:=-1, ColumnOffset:=2).Address
\r\nEnd Sub
\r\nIs the SAME as;
\r\nSub OffsetMe()
\r\n MsgBox Range(\\"B2\\").Offset(-1,2).Address
\r\nEnd Sub
\r\nOFFSET FORMULA
\r\nReturns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.Syntax = OFFSET(reference,rows,cols,height,width)
\r\n
\r\nExamples
\r\n=OFFSET(C3,2,3,1,1) Displays the value in cell F5.
\r\n=OFFSET(C3:E5,0,-3,3,3) Returns an error, because the reference is not valid.\", \"style=\\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\\"\");" style="FONT-STYLE: italic" onmouseout="GAL_hidepopup();" href="http://www.ozgrid.com/forum/autolink.php?id=5&script=showthread&forumid=8">cell is formatted as Text, then it will display the #### when the text is over the limit. Reformat the cell to General and the text should again show.

Right click on the cell, click Format Cells, under the number tab, choose General.

Also, this ####, will occur is the cell width is to small.

May 16, 2008 | Microsoft Excel for PC

1 Answer

EXCEL


Add an IF statement that encloses the formula you've already written. Assuming the result is in one cell, called CELLREF for purposes of writing this for you:
=If(CELLREF>0,CELLREF,(------INSERT YOUR FORMULA ABOVE------),0)
Thank you for rating FixYa!

Apr 23, 2008 | Microsoft Excel for PC

1 Answer

Data validation in excel


instead of validation use conditional formating (under format menu). If c1<1 format cell as red. It does not have the attention getter that validation does not require the active cell event. Every other option requires the cell become active for a test.

Apr 13, 2008 | Business & Productivity Software

1 Answer

Excell


=if(B2>0,B2+20,0)

in this case if the value of cell B2 is greater than 0, the value will be added to 20, if its less than zero it will return the answer 0.

Mar 13, 2008 | Business & Productivity Software

1 Answer

Excel and the AVERAGE function


Here is one way:

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

Dec 30, 2007 | Business & Productivity Software

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

133 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...