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

hi maybe the formula below will help you

A rational number is a number that can be expressed as a fraction with an integer numerator and a non-zero natural number denominator. Fractions are written as two numbers, the numerator and the denominator, with a dividing bar between them. In the fraction written*m*⁄*n* or

*m* represents equal parts, where *n* equal parts of that size make up one whole. Two different fractions may correspond to the same rational number; for example 1⁄2 and 2⁄4 are equal, that is:

If the absolute value of*m* is greater than *n*, then the absolute value of the fraction is greater than 1. Fractions can be greater than, less than, or equal to 1 and can also be positive, negative, or zero. The set of all rational numbers includes the integers, since every integer can be written as a fraction with denominator 1. For example −7 can be written −7⁄1. The symbol for the rational numbers is **Q** (for *quotient*), also written .

A rational number is a number that can be expressed as a fraction with an integer numerator and a non-zero natural number denominator. Fractions are written as two numbers, the numerator and the denominator, with a dividing bar between them. In the fraction written

If the absolute value of

Jun 27, 2010 | Cobra 29 LTD CB Radio

Hi,

First let us repair the terminology.

Hope it helps.

Thank you for using FixYa and for rating this solution.

First let us repair the terminology.

- You can evaluate any expression (find the value of any expression for a particular value of its variable).Store a value in the variable, say X. Key in the expression and press [EXE].
- You can consider your expression(should not contain a relational operator such as =, greater than, less than, greater than or equal to, less than or equal to) to be a function Y1(x) = expression and graph it, or generate a table for it. You will have several values of the function calculated at various points.
- You can set your expression equal to 0 and find the particular value(s) of the variable (the unknown) that make the equality TRUE. That is called solving an equation.

Hope it helps.

Thank you for using FixYa and for rating this solution.

Nov 05, 2009 | Casio FX-7400G Plus Calculator

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

Convert to UPPER, Proper or lower

Auto Convert to UPPER, Proper or lower

Stop VBA Being Case Sensitive

Select Case Statement. Great alternative to Else If Statements

VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().

dDate=cDate("25-Jan-07")

Convert Numbers to Words

Convert Numbers to Dollar Amount in Words

Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $

SQL Database Migration $

Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $

CSV Converter $

Import SQL Into Excel-SQL Tester $

Import Excel Into Access $

Conditional Formatting

More Than 3 Conditional Formats

Conditional Format Fonts for greater than 3

Custom Formats

Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like

To hide zeros on the Workbook level go to

Dec 15, 2008 | Microsoft Windows XP Home Edition

You did not respond to my claification request. Here is some code that might help, it copies a selection of cells going down until an emty cell is found and across until an emty cell is found. This is form an earlier version of office but should comeclose to woring in 2007.

Sub copyrange()

'

' copyrange Macro

' Macro written by Royal 11/22/2008.

'

'save the return values

wksname = ActiveSheet.Name

returncell = ActiveCell.Address

searchfor = ActiveCell.Value

'go to first worksheet and find entered value (note this is a value serach)

Worksheets(1).Activate

findfor = "A1"

On Error Resume Next

findfor = Cells.Find(What:=searchfor, After:=ActiveCell, LookIn:=xlValues, LookAt:= _

xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _

False).Address

If findfor = "A1" Then

erwks = ActiveSheet.Name

Sheets(wksname).Activate

er = MsgBox("Search item not found on Worksheet" + erwks, , "Search Error")

Exit Sub

Else

findfor.Activate

End If

Cells.FindNext(After:=ActiveCell).Activate

'save this address and start searching for copy area boundaries

begcell = ActiveCell.Address

begcl = ActiveCell.Cells.Column

begri = ActiveCell.Cells.Row

'search amaximum of 1000 rows and 676 columns

endri = begri + 1000

endcl = 26 * 26

maxrow = 0

maxcol = 0

For col = Cells.Column To endcl

If Cells(begri, col) = "" Then

maxcol = col

col = endcl

ri = endri

Else

ri = begri

End If

For ri = ri To (Cells.Row + 1000)

If Cells(ri, col) = "" Then

If ri > maxrow Then

maxrow = ri

End If

ri = endri

End If

Next ri

Next col

maxrow = maxrow - 1

maxcol = maxcol - 1

'copy the selected area

endcell = Cells(maxrow, maxcol).Address

crnge = begcell & ":" & endcell

Range(crnge).Select

Selection.Copy

'go back and paste it in

Sheets(wksname).Activate

Range(returncell).Select

' use this if yo want to paste formulas etc.

'ActiveSheet.Paste

' use this code if you want to paste values instead of formulas etc.

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _

False, Transpose:=False

Range(returncell).Select

Sub copyrange()

'

' copyrange Macro

' Macro written by Royal 11/22/2008.

'

'save the return values

wksname = ActiveSheet.Name

returncell = ActiveCell.Address

searchfor = ActiveCell.Value

'go to first worksheet and find entered value (note this is a value serach)

Worksheets(1).Activate

findfor = "A1"

On Error Resume Next

findfor = Cells.Find(What:=searchfor, After:=ActiveCell, LookIn:=xlValues, LookAt:= _

xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _

False).Address

If findfor = "A1" Then

erwks = ActiveSheet.Name

Sheets(wksname).Activate

er = MsgBox("Search item not found on Worksheet" + erwks, , "Search Error")

Exit Sub

Else

findfor.Activate

End If

Cells.FindNext(After:=ActiveCell).Activate

'save this address and start searching for copy area boundaries

begcell = ActiveCell.Address

begcl = ActiveCell.Cells.Column

begri = ActiveCell.Cells.Row

'search amaximum of 1000 rows and 676 columns

endri = begri + 1000

endcl = 26 * 26

maxrow = 0

maxcol = 0

For col = Cells.Column To endcl

If Cells(begri, col) = "" Then

maxcol = col

col = endcl

ri = endri

Else

ri = begri

End If

For ri = ri To (Cells.Row + 1000)

If Cells(ri, col) = "" Then

If ri > maxrow Then

maxrow = ri

End If

ri = endri

End If

Next ri

Next col

maxrow = maxrow - 1

maxcol = maxcol - 1

'copy the selected area

endcell = Cells(maxrow, maxcol).Address

crnge = begcell & ":" & endcell

Range(crnge).Select

Selection.Copy

'go back and paste it in

Sheets(wksname).Activate

Range(returncell).Select

' use this if yo want to paste formulas etc.

'ActiveSheet.Paste

' use this code if you want to paste values instead of formulas etc.

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _

False, Transpose:=False

Range(returncell).Select

Nov 20, 2008 | Computers & Internet

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

you are probably reading to a inteligent software package like Excell, which sees the inputted data as a number (so ignores leading zeros) you need to specify to the sytem that the incoming numbers are TEXT not numbers.

Sep 30, 2008 | Symbol LS2208 Handheld

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

87 people viewed this question

Usually answered in minutes!

×