Question about Computers & Internet

=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.

Posted on Mar 14, 2008

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

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

Cheers

Oct 28, 2011 | Microsoft Excel for PC

Need to have a greater than or equal to on one otherwise excell will get confused.

Nov 29, 2010 | Microsoft Office Excel 2003 for PC

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help:
ROUND(number,num_digits)
The number you want to round.
• None.
num_digits The number of digits to which you want to round number.
• If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
• If num_digits is 0, then number is rounded to the nearest integer.
• If num_digits is less than 0, then number is rounded to the left of the decimal point.

So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

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

lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

Nov 13, 2008 | Computers & Internet

If a RANGES

\r\nNamed 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\n**OFFSET RANGES VBA**

\r\nReturns a Range object that represents a range that?s offset from the specified range. Read-only.

\r\n*expression.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\n*Example*

\r\n**Sub OffsetMe()**

\r\n MsgBox Range(\\"B2\\").Offset(RowOffset:=-1, ColumnOffset:=2).Address

\r\n**End Sub**

\r\nIs the SAME as;

\r\n**Sub OffsetMe()**

\r\n MsgBox Range(\\"B2\\").Offset(-1,2).Address

\r\n**End Sub**

\r\n**OFFSET 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\n*Examples*

\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.

\r\nNamed 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\n

\r\nReturns a Range object that represents a range that?s offset from the specified range. Read-only.

\r\n

\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\n

\r\n

\r\n MsgBox Range(\\"B2\\").Offset(RowOffset:=-1, ColumnOffset:=2).Address

\r\n

\r\nIs the SAME as;

\r\n

\r\n MsgBox Range(\\"B2\\").Offset(-1,2).Address

\r\n

\r\n

\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\n

\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

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!

=If(CELLREF>0,CELLREF,(------INSERT YOUR FORMULA ABOVE------),0)

Thank you for rating FixYa!

Apr 23, 2008 | Microsoft Excel for PC

The eomoth function returns the last day of the month.

Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

eomonth (1/2/08, 1) will return 31. The number of days in the month.

eomonth (1/2/08, 2) will return 59, The number of days in the month plus the next month (February)

Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

eomonth (1/2/08, 1) will return 31. The number of days in the month.

eomonth (1/2/08, 2) will return 59, The number of days in the month plus the next month (February)

Mar 06, 2008 | Microsoft Excel for PC

You can use an IF statement:

**IF**(**logical_test**,**value_if_true**,value_if_false)

In your case, this would be:

=IF(B6<>"",SUM((B6+D6)-(B5+C6)),"")

This works as follows:

IF(B6<>"", : If B6 is not equal to nothing, ie. it equals something

SUM((B6+D6)-(B5+C6)), : Set the value as per the equation

"") : Otherwise set the value to nothing.

Of course, this only checks that there is a value in B6. Depending on that value (and that of the other cells) you could still get a negative result. The way to avoid this would be to use the following:

=IF((SUM((B6+D6)-(B5+C6))>0),SUM((B6+D6)-(B5+C6)),"")

A bit long winded, but basically it checks the result of the sum is greater than 0. If it is it displays it, if not it leaves the cell blank.

Hope this helps,

Matt

In your case, this would be:

=IF(B6<>"",SUM((B6+D6)-(B5+C6)),"")

This works as follows:

IF(B6<>"", : If B6 is not equal to nothing, ie. it equals something

SUM((B6+D6)-(B5+C6)), : Set the value as per the equation

"") : Otherwise set the value to nothing.

Of course, this only checks that there is a value in B6. Depending on that value (and that of the other cells) you could still get a negative result. The way to avoid this would be to use the following:

=IF((SUM((B6+D6)-(B5+C6))>0),SUM((B6+D6)-(B5+C6)),"")

A bit long winded, but basically it checks the result of the sum is greater than 0. If it is it displays it, if not it leaves the cell blank.

Hope this helps,

Matt

Mar 03, 2008 | Microsoft Excel for PC

Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Dec 03, 2007 | Computers & Internet

87 people viewed this question

Usually answered in minutes!

×