Addition And Subtraction Using IF Formula

May 1, 2013

Lets say I have a #2 in cell A1 and #4 in cell B1 and would like an output in C1 as "plus 2".

Right now I have =if(a1>b1,b1-a1,???) what can I put in the [value_if_false] to return "plus 2" or do I have to use another formula?

View 1 Replies


ADVERTISEMENT

Subtotal Formula - Function 109 Does Subtraction (not Addition)

May 28, 2013

I'm looking for a formula that acts the same way as the subtotal formula (revises if rows are hidden and only adds visible rows). Is there anyway to get this removal of hidden rows but for subtraction?

View 3 Replies View Related

Addition/Subtraction With Menu Selection

Jan 8, 2009

Included is an example of a spreadsheet I am working on. There are multiple choices within several different drop-down menu's. As of right now I have the 1st menu as the stage of completion of a car. Within the next few menu's are options.

If welded chassis is chosen, none of these options are included. However if roller or turn-key are chosen then some of these options are included. But then there are also upgrades to these parts that are included as well. Is there a way to make 1 option included when a roller is chosen, but then if you want the 2nd option in the menu, you click on it and it automatically updates the price next to it, therefore subtracting the cost of option 1 from the cost of option 2?

View 2 Replies View Related

Basic Addition, Subtraction & Multiplication

Apr 12, 2008

Take a single cell in column D, and multiply it by a single cell in column E, which will equal F. Take column F, and multiply it by .02 (2%), which will equal G. Take a cell in column G, and subtract it from F, which will equal I. And this all takes place in the same row. Then have it move down to the next row, and do the same thing..... so it would basically look like this.....

A B C D E F G H I
1 D1 E1 (D1*E1) (F1*.02) (G1-F1)

2 D2 E2 (D2*E2) (F2*.02) (G2-F2)

3 D3 E3 (D3*E3) (F3*.02) (G3-F3)

For easier reading.... in each row I want it to do the following math
D*E=F
F*.02=G
G-F=I

And then do it for every row that I have data in (excluding the VERY first row). I am -COMPLETELY- sorry if I broke any rules, and am also sorry for the poor representation

View 5 Replies View Related

Subtraction Formula

Oct 21, 2009

I have data that when added together will have decimals of .1 or .2. Any decimal great than .2 becomes an integre of 1 and is added to the other integres. for example: 1.1, 2.0, 3.2, 5.1=12.1.

I now want to subtract this total from another amount that will give me values with decimals of .1 or .2, example: 59-12.1=46.2 not 46.8. The same if 62-8.1=53.2.

View 9 Replies View Related

Formula For Minute Subtraction?

Mar 6, 2014

What is the formula for taking two times, and finding the minutes between them. E.g. 12:35 PM-12:28 PM=7. I know i can use (A1-A2)*1440, but is there an easier way?

View 4 Replies View Related

Time Subtraction Formula

Nov 28, 2013

I'm trying to do the following:

In the attached file, I'd like to subtract whichever is the earliest time between B4 or C4 from A4, then B5 or C5 from A5, etc.

I assume I need a conditional "if" statement but I'm not sure if that will work.

Attached File : Time Subtraction Example.xls‎

View 7 Replies View Related

Simple Subtraction Formula Not Calculating

Nov 21, 2007

I've got a list of marks (col T), and I want to create a new column subtracting 5 from each value.

Obviously, the formula in this new column is
=T1-5
=T2-5
etc...

But I enter that formula and excel doesn't do any calculating, it just displays "T1-5"
It even seems to recognize that it's a formula, highlighting T1 in the formula and the T1 cell itself, but no resulting value...

I've tried changing the format of the cells (in both columns) to Number and back to General again, but without success.

I've also tried copying and pasting (values only) the whole T column to another column, and tried there, also without any success.

View 9 Replies View Related

Add Subtraction Formula To Cell Via Code

Aug 11, 2007

If I wish to amend the below code such that it must use the cell one row above minus the cell on the left, how should I go about it?

Eg,

If in cell C10, the formula is to use C9 minus B10.
If in cell C11, the formula is to use C10 minus B11.

mylogoff.Offset(0, 1).FormulaR1C1 = "=RC[-1]-RC[-2]

View 5 Replies View Related

Formula For Month Subtraction From Date Format

Apr 24, 2014

What is the simple formula to be used to subract N months from MM.YYYY format

ex:1
Here N=2, MM=04,YYYY=2014

04.2014 minus 2 month means output should be 02.2014

ex:2
02.2014 minus 2 month means output should be 12.2013

View 2 Replies View Related

Formula That Will Look In Col A And Perform A Subtraction In Cell B1 Between 2 Value Dates

Jan 4, 2009

i need formula that will look in Col A and perform a subtraction in Cell b1 between 2 value dates 28/12/08 -12/12/08. Though I could have done this manually but was wondering if there is formula which will avoid duplicate dates. So the formula is set and when i copy new data in Col A daily the formula should be able to pick 2 dates regardless where the second date starts at...

View 9 Replies View Related

Add Addition If Condition To Existing Formula: Long Formula

Aug 12, 2007

This task joins a string together based on a number of characters per cell in the range.

I want to isolate one range, Col N, and add an IF condition to it.

There may be other issues preventing this from happening, e.g. the number of IF that exist in the complete formula. I will isolate the current cell and its requirements and then post the entire formula at the end for reference....

View 9 Replies View Related

Addition Formula

Aug 13, 2008

I am a new excel user. I a trying to write a certain formula but am having trouble. I want to write the formula to add a column of numbers, say H-10 through H-15. Each cell will have a number in it, but I want only to add the cells if the cell precedding it in the G-10 through G-15 Collumn is blank. For example if cells G-12 and G-14 have an "X" in them, then I do not want Cells H-12 and H-14 to be added. I only want the formula to add cells H-10,H-11,H-13, and H-15. I used just 6 cells for example, the column of cells to be added will be a lot longer.

View 3 Replies View Related

Insert Addition Formula With VBA

Jan 11, 2013

I wish to sum specific rows in a spreadsheet as a Grand Total. I eventually end up with a string variable called "GrandTot" that holds "=C3+C13+C25+C31+C39+C50+C53"

This formula is correct, but when I insert it into the spreadsheet it totals zero. Only when I manually write the formula does it recognize the cells it supposed to add. I am very confused as to why this is happening.

On a possibly related note, when I highlight a column in the spreadsheet, the count is including blank cells.

View 3 Replies View Related

Calculator Formula For Addition Via Columns

Oct 20, 2009

I would like to know the calculator formula for addition via columns.

Eg 1. If i were to place 135 into Column A ;
12.95 into Column C ;
i would need to yield a result of 147.95

Eg 2. Place 189 into Column A ;
12.95 into Column C

i would need to yield result of 201.95 and so on. in the attachment is the sample file.

View 2 Replies View Related

Update Csa Formula With The Addition Of New Rows

Jun 20, 2007

I am working on a spreadsheet that matches each cell in Column B (text) with the data (text) in a constant cell; if there is a match, the data that corresponds to the data in Column B (text) will average (Column G, number) using a CSA formula, for example: =AVERAGE(IF($B$3:$B$106=A$110,$G$3:$G$106))

Now the formula above works well, only I have to update the spreadsheet, so when I add new rows the $B$3:$B$106 and $G$3:$G$106 portions are useless.

Trying to use the INDIRECT function that many people successfully use in this forum, produces a #VALUE error,

=AVERAGE(IF(INDIRECT("$B$3:B"&ROW()-4)=A$111,(INDIRECT("$G$3:G"&ROW()-4))))

View 9 Replies View Related

Sumif Formula Needs To Split 2 Criterias Of Addition

Aug 6, 2009

you guys very kindly helped me with a spreadsheet a couple of months ago, but i now need to adapt it for another dept. I have completed as much as I can.

I need column C and E in the 'totals tab' to only calculate contract and upgrade sales respectively (found in 'service orders' tab). I also need Scott's and ash's individual sales to be calculated in corrisponding tabs. Most of the formulas are in place so just need them tweaked slightley.

View 4 Replies View Related

Sumproduct Formula And When To Use Comma's, Double Negatives, Addition

Jan 21, 2010

look at my attachment and see what I am doing wrong in my formula? I have a hard time understanding the Sumproduct formula and when to use comma's, double negatives, addition, etc.

View 2 Replies View Related

Make A Calculation(addition) And Use The Answer To Multiply Against Another Addition Calculation

Nov 19, 2008

make a calculation(addition) and use the answer to multiply against another addition calculation....

The sum of (Monday!A1:A4) multiplied by the sum of (Monday!B1:B4) plus (Tuesday!A1:A4) multiplied by the sum of (Tuesday!B1:B4) and so on.

View 2 Replies View Related

Subtraction Without Borrow

Nov 2, 2008

Is thee any formula to deduct the higher value from a lower value without carrying. for example:

A1 = 01234
A2 = 56789

A3= should be = 55555

is there any formula like this

View 14 Replies View Related

Conditional Subtraction

Jan 9, 2008

Im using the following formula


=IF(E5"",NETWORKDAYS(E5,IF(F5="",TODAY(),F5),Holidays),"")

to calculate training shifts spent in my training centre. We have 2 sets of occupational groups, those of underground & those of surface. I need to subtract 1 shift from the formula but only for the underground guys.

View 9 Replies View Related

Sum Function But For Subtraction

Jul 27, 2006

Is there a " Sum" function that can be used for a cumulative series of subtractions?

For example, if I have 10, 12 and 15 in 3 respective cells, and use the sum function upon them, it will return 37.

However, I want to say 10 minus 12 minus 15, and thus return -17.

View 3 Replies View Related

Floating Binary In Subtraction

Oct 13, 2008

cell A1 contains the numeric value: 3961.3
cell A2 contains the follwing: ="z equals "&B3-3933.7

which i would expect to give me: "z equals 27.6"

BUT, it gives me: "z equals 27.600000004"

which is awefully strange becos the 4 comes form nowhere...

what makes some sort of sense is that if the value in A1 is changed to 3961.4 or 3961.5, then the final decimal 4 in A2 changes into a 3, and then a 2.

when the value in A1 is changed to xxxx.7 the number in cell A2 becomes what one would expect it to be.

how do i get rid of these strange decimals???

(formatting cells, setting number of significant figures does not work. i naturally already tried that)

View 8 Replies View Related

Subtraction Based On Next Cell Value

Jun 19, 2014

I would like if active row cell "AF" has the words "Visa Signature, the same active row "AP" value, 25 should be subtracted from it.

View 3 Replies View Related

Subtraction Macro Request

Jul 12, 2007

I have Time Data in one column, and Values in the next, and then a blank column (for calculations, like subtraction/time).

Is there any way to automate the =Cell2-Cell1 command for regions of blue cells and have it paste the value in the blank column lined up with the first blue cell of the region?

The attachment will make more sense, but this is what I'm talking about:

Before subtraction macro:

BlueTime1 Value Blank BlueTime4 Value Blank
BlueTime2 Value Blank BlueTime5 Value Blank
BlueTime3 Value Blank BlueTime6 Value Blank
Blank Blank Blank Blank Blank Blank
BlueTime7 Value Blank BlueTime10 Value Blank
BlueTime8 Value Blank BlueTime11 Value Blank
BlueTime9 Value Blank BlueTime12 Value Blank

After subtraction macro:

BlueTime1 Value BlueTime3-BT1 BlueTime4 Value BlueTime6-BT4
BlueTime2 Value Blank BlueTime5 Value Blank
BlueTime3 Value Blank BlueTime6 Value Blank
Blank Blank Blank Blank Blank Blank
BlueTime7 Value BlueTime9-BT7 BlueTime10 Value BlueTime12-BT10
BlueTime8 Value Blank BlueTime11 Value Blank
BlueTime9 Value Blank BlueTime12 Value Blank

View 11 Replies View Related

IF Statement With Date Subtraction

Jul 9, 2007

I am trying to use a IF statement to extract date data by months.

e.g. : =IF(I13134="A",H13134(Date field) - (date by 3 months)

I hope that makes sense:

So I guess if the field I13134 has the letter "A" in it - Look at field H13134 and subtract that date by 3 months.

View 9 Replies View Related

Negative Time Subtraction

Jul 18, 2006

Ecel 2000

If Ii subtract time
eg 22:00-01:00 I get ############### wrong
If I subtract 22:00 23:00 I get 1 HR correct

View 3 Replies View Related

Time Calculations Subtraction And Average?

Dec 10, 2013

1st problem concerns entering data as text and it being converted to time. I have found the formula 00:00 which does an excellant job of converting. However, when I want to subtract, (=a2-a1) for example, it treats the time as a number. Sometimes it works, but if the hours are different, say 23:30- 22:10, it will subtract 2330-2210! Is there a way to make this work?

2nd problem, related to the first is when I try to avg a column of times, I get a similar effect.

View 1 Replies View Related

How To Mark Subtraction Total As Red Text

Jan 21, 2013

was wondering if it was possible to mark a text or cell as red every time a subtraction was made and also to show the total cell or text as red whenever a link is made ?

View 3 Replies View Related

Setting Range Of Numbers And Performing Subtraction?

Mar 28, 2014

I am creating a range of numbers from 1 to 2000 with increments of 0.5. Then I have to subtract certain range, for example, 100 to 350. So, the result should display, 1 to 95.5 and 350.5 to 2000.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved