I want to be able to add a value from cell "a" to cell #1 only if cell #2 contains a value or text, then I want to add a second value from cell "b" to cell #1 only if cell #3 contains a value or text, finally, when cell #4 contains a value or text I want cell #1 to drop the values in cells "a" & "b" and add the value in cell "c". Can I do this using if and then?

thanks

Ian

Ad

Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:

=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

Posted on Dec 30, 2007

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Sequencing is a formula =A1+1. If you insert a cell you can re-s

equence by doing a autofill in the column that contains the sequence number.

i.e.

Cell A1 value= 1

Cell A2 =A1+1 (value will be 2)

If you auto-fill the entire column will sequence:

=A2+1 (value will be 3)

=A3+1

etc.

equence by doing a autofill in the column that contains the sequence number.

i.e.

Cell A1 value= 1

Cell A2 =A1+1 (value will be 2)

If you auto-fill the entire column will sequence:

=A2+1 (value will be 3)

=A3+1

etc.

Jul 03, 2017 | The Computers & Internet

Correct a #N/A error
Show All
Hide All
This error occurs when a value is not available to a function or formula.

- Optionally, click the cell that displays the error, click the button that appears , and then click
**Show Calculation Steps**if it appears. - Review the following possible causes and solutions.
Missing data, and #N/A or NA() has been entered in its place

Replace #N/A with new data.

**Note**You can enter**#N/A**in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.

Giving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function

Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. Using the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table

By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.

Using an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula

If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).

Omitting one or more required arguments from a built-in or custom worksheet function

Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.

Using a custom worksheet function that is not available

Make sure that the workbook that contains the worksheet function is open and the function is working properly.

Running a macro that enters a function that returns #N/A

Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

Sep 07, 2014 | Microsoft Excel for PC

Private Sub cmdBack_Click()

Dim temp As String

Dim leng As Integer

If txt1.Text = " " Then

MsgBox "Text box has no value!", vbInformation

Else

temp = Str(txt1.Text)

leng = Len(temp)

txt1.Text = ""

For i = 1 To leng - 1

txt1.Text = Mid(temp, 1, i)

Next i

End If

End Sub

_________________ add this code 2 ur number example

cmdBack.Enabled = True <<add this

to able the backspace

any suggestion my email add in facebook johnpaulzzzz@yahoo.com

Dim temp As String

Dim leng As Integer

If txt1.Text = " " Then

MsgBox "Text box has no value!", vbInformation

Else

temp = Str(txt1.Text)

leng = Len(temp)

txt1.Text = ""

For i = 1 To leng - 1

txt1.Text = Mid(temp, 1, i)

Next i

End If

End Sub

_________________ add this code 2 ur number example

cmdBack.Enabled = True <<add this

to able the backspace

any suggestion my email add in facebook johnpaulzzzz@yahoo.com

Oct 26, 2010 | Texas Instruments TI-30XA Calculator

#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

I hope this helps and thanks for rating my effort...any other questions...shoot em to me....The Fang.

Restricting character input You can use the SetInputTextType command to restrict the characters that the user can enter in the text input dialog box. For example, suppose an application contains an input text field for users to provide a numeric value, such as their age, and that the input text field has the variable name ageVar. To ensure that the user enters only numeric values in the text input dialog box, you could add the following code to your application:

fscommand2("SetInputTextType", "ageVar", "Numeric");

When users open the input text dialog box, they can enter only numeric values in the text fields.

For more information, see SetInputTextType in the fscommand2 function entry in the*Flash Lite 2.x ActionScript Language Reference*.

Restricting character input You can use the SetInputTextType command to restrict the characters that the user can enter in the text input dialog box. For example, suppose an application contains an input text field for users to provide a numeric value, such as their age, and that the input text field has the variable name ageVar. To ensure that the user enters only numeric values in the text input dialog box, you could add the following code to your application:

fscommand2("SetInputTextType", "ageVar", "Numeric");

When users open the input text dialog box, they can enter only numeric values in the text fields.

For more information, see SetInputTextType in the fscommand2 function entry in the

May 28, 2009 | Adobe Flash® CS3 Professional Full Version...

just send me your mail address along with this problem in detail at searcherrate19@yahoo.com and believe me i will solve it in a jiffy.

May 23, 2009 | Computers & Internet

Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

In Actionscript 2.0 the output to the script below will be 15. Make sure that the values for the variables do not contain strings or extra characters like quotation marks.
num1 = 5;
num2 = 10;
sum = num1 + num2;
trace(sum);

Sep 28, 2007 | Macromedia Flash MX

Raju, There's no easy way to do it as far as I know.
What you can do is create a table where in column A you'll have the sum, in this case 300 and in column B you'll have the text i.e. Rupees Three Hundred Only
Then you need to use the Vlookup function to retrieve the right text to the number you get.

Sep 15, 2007 | Microsoft Office Standard for PC

Oct 15, 2018 | Computers & Internet

Oct 15, 2018 | Computers & Internet

153 people viewed this question

Usually answered in minutes!

×