Excel Formula

Users who are viewing this thread

Total: 3 (members: 0, guests: 3)
Aeval

Aeval

Active Member
Messages
3,665
Reaction score
1
Tokenz
0.10z
I'm not sure if this in the correct area but I need to know how to enter a formula and hope someone can help.

I need to SUM a column IF there's data in another column...I'm trying to create a spreadsheet that automatically adds a cheque amount when I put the "cleared date" in another column.

I've messed around with it for a half hour now and that's about my limit.

HELP!!
 
  • 23
    Replies
  • 2K
    Views
  • 0
    Participant count
    Participants list
rback33

rback33

Back Again... but reformed...
Messages
4,570
Reaction score
2
Tokenz
0.00z
Oh boy.... let me make sure I understand what you are wanting to do... you want to make a formula that makes a sum including a cell (a)... but ONLY includes it if there is data in another cell (b).....

I could be wrong, but I don't know if Excel will allow this. Anytime I goof a formula I know it throws and error when I reference a cell with no data or improperly formatted data.... but MAYBE you can construct one to recognize that incomplete data is intentional and... damn.... I don't know the answer for sure but am now curious about it.
 
Aeval

Aeval

Active Member
Messages
3,665
Reaction score
1
Tokenz
0.10z
rback33 said:
Oh boy.... let me make sure I understand what you are wanting to do... you want to make a formula that makes a sum including a cell (a)... but ONLY includes it if there is data in another cell (b).....

I could be wrong, but I don't know if Excel will allow this. Anytime I goof a formula I know it throws and error when I reference a cell with no data or improperly formatted data.... but MAYBE you can construct one to recognize that incomplete data is intentional and... damn.... I don't know the answer for sure but am now curious about it.
Click to expand...

Maybe it can't be done, I've been messing around with it because it would be sweet if it would do it.

Yes, that's what I want.

Thanks!
 
Aeval

Aeval

Active Member
Messages
3,665
Reaction score
1
Tokenz
0.10z
It worked, it worked, it worked!

Now everyone here thinks I'm a genius...hahahaha. Little do they know!:p
 
Weebs

Weebs

Member
Messages
290
Reaction score
0
Tokenz
0.00z
Damn that looks involved... There are often opportunities at my place of employment (positions I know I could fill well) However one of the requirements is a
basic understanding of Excel. Stuff looks like rocket science. :willy_nilly:
 
Kyle B

Kyle B

V.I.P User
Messages
4,721
Reaction score
1
Tokenz
0.00z
I took a class on Excel a few semesters ago. Believe it or not, formulas are pretty basic, but they can definitely look like a foreign language to people not familiar with Excel.

IF statements work like this:

=IF(The condition, if the condition is true enter this value, if the condition is false enter this value)

Example: =IF(A1>2,"Yes","No")

If A1 is greater than the value 2, enter "Yes", if the value is not greater than 2, enter "No"

That's actually a pretty simple one, but that's just to give one example.

Also:

"A1:B5" Would mean All cells from A1 to B5

"$B2$" Makes the cell B2 a constant in a formula. So, you would enter that if you wanted a bunch of cells to be individually multiplied by B2. An example would be multiplying the Gross pay on a payroll spreadsheet by the tax rate.
 
Weebs

Weebs

Member
Messages
290
Reaction score
0
Tokenz
0.00z
Kyle B said:
I took a class on Excel a few semesters ago. Believe it or not, formulas are pretty basic, but they can definitely look like a foreign language to people not familiar with Excel.

IF statements work like this:

=IF(The condition, if the condition is true enter this value, if the condition is false enter this value)

Example: =IF(A1>2,"Yes","No")

If A1 is greater than the value 2, enter "Yes", if the value is not greater than 2, enter "No"

That's actually a pretty simple one, but that's just to give one example.

Also:

"A1:B5" Would mean All cells from A1 to B5

"$B2$" Makes the cell B2 a constant in a formula. So, you would enter that if you wanted a bunch of cells to be individually multiplied by B2. An example would be multiplying the Gross pay on a payroll spreadsheet by the tax rate.
Click to expand...


See that's my problem.. I can never understand the phase coupling. Especially if my phase inverter is offline... :p



Seriously... Stuff reminds me of basic "tables" html. I hated it, and was glad to get a wysiwyg program for making web pages. That was years ago however... I think there is a reason I drive a truck for a living. lol
 
Aeval

Aeval

Active Member
Messages
3,665
Reaction score
1
Tokenz
0.10z
I wish I knew more about it, I use excel more at this job than I did at the last one. Google, and that site Darrell gave me are used daily.:D
 
Last edited by a moderator:
Kyle B

Kyle B

V.I.P User
Messages
4,721
Reaction score
1
Tokenz
0.00z
Weebs said:
See that's my problem.. I can never understand the phase coupling. Especially if my phase inverter is offline... :p



Seriously... Stuff reminds me of basic "tables" html. I hated it, and was glad to get a wysiwyg program for making web pages. That was years ago however... I think there is a reason I drive a truck for a living. lol
Click to expand...

If you have trouble writing out the formulas, you can have them entered for you. Just click on the cell you want the formula to apply to. Then go to the Functions Library group in the Formula Tab. Click the formula you want. It will give you a dialogue box and ask you to enter the information. Then Excel creates the formula for you.

You only have to do it once too.

Once you have the formula in the cell, you can apply that formula to numerous cells. Let's say that you have a bunch of columns, and you want the total of each column. No need to go through the steps above for each one; just enter the formula for the first column. Then click on that tiny little box at the lower right of a highlighted cell. Drag it to the cells you want the formula to apply to. Excel will make the adjustments so that each column is totaled.
 
darkcgi

darkcgi

Glorified Maniac
Messages
7,475
Reaction score
448
Tokenz
0.28z
just a snip
if ((b1.x2 - b1.x1) % 7 == 0)
w = 7 * ((b1.x2 - b1.x1) / 7);
else
w = 7 * (1 + ((b1.x2 - b1.x1) / 7));
if ((b1.y2 - b1.y1) % 7 == 0)
h = 7 * ((b1.y2 - b1.y1) / 7);
else
h = 7 * (1 + ((b1.y2 - b1.y1) / 7));
 
78,874Threads
2,185,387Messages
4,959Members
Back
Top