# Search:

Type: Posts; User: lzweifel; Keyword(s):

Page 1 of 6 1

## Search: Search took 0.01 seconds.

by lzweifel
Replies
1
Views
95

### Adding a percentage to currency in specific cells

This can't be complicated... I have a huge amount of cells with figures already inputted into them. I would like to simply add a percentage to those cells.

Thanks a bunch

L
2. ## Thread: Formula to calculate IF a certain cell has data and leave blank if not.

by lzweifel
Replies
10
Views
269

### Re: Formula to calculate IF a certain cell has data and leave blank if not.

PERFECT!!!!! Thank you so much for your help!! Much appreciated!
3. ## Thread: Formula to calculate IF a certain cell has data and leave blank if not.

by lzweifel
Replies
10
Views
269

### Re: Formula to calculate IF a certain cell has data and leave blank if not.

Yes, you have it correct..... I have a row, which in the column B may or may not have information entered into it. IF information is entered in I want my rates to appear in another column (first...
4. ## Thread: Formula to calculate IF a certain cell has data and leave blank if not.

by lzweifel
Replies
10
Views
269

### Re: Formula to calculate IF a certain cell has data and leave blank if not.

Yes that works Fluff... thank you. Now what if I want to have a formula to calculate within that. So, now...

=IF(B26)<>"", (I26*G26) So, if there is information in B26 that would populate I26...
5. ## Thread: Formula to calculate IF a certain cell has data and leave blank if not.

by lzweifel
Replies
10
Views
269

### Formula to calculate IF a certain cell has data and leave blank if not.

I know this is simple, but I can't quite get it...

IF B26 has any information I want H26 to deliver \$155.00, but if B26 has no information in it I want it left blank.

L
6. ## Thread: If Formula to calculate dates and amounts

by lzweifel
Replies
1
Views
150

### If Formula to calculate dates and amounts

Hello all, happy hump day!

I have columns for 30days past invoice date, 60days past invoice date, 90days etc.

The formula is set to record a date according to todays date vs invoice date and...
7. ## Thread: Conditional formatting for an entire row based on one cell

by lzweifel
Replies
13
Views
926

### Re: Conditional formatting for an entire row based on one cell

Hi... can you send me the link again to do this?
8. ## Thread: Entering New Data from the TOP

by lzweifel
Replies
3
Views
108

### Re: Entering New Data from the TOP

Hi, how can you help me with this?

Meaning, what (how) do I send to you to show you want I have and need? Basically it is just at current 10 columns of data and 25,000 rows. I have the data...
9. ## Thread: Entering New Data from the TOP

by lzweifel
Replies
3
Views
108

### Entering New Data from the TOP

Hi all,

I have a very simple spreadsheet but lots of data, 35,000 rows. Is there a way to enter data (new row) from the top?
10. ## Thread: Sending SMS messages from Excel List

by lzweifel
Replies
1
Views
74

### Sending SMS messages from Excel List

Hi All,

I have already posted this question, but unable to find it or the answer.

I have a list of names and phone numbers and would like to be able to use it to send out SMS messages, can...
11. ## Thread: Sent mass SMS via Excel

by lzweifel
Replies
1
Views
106

### Sent mass SMS via Excel

Hi, I see there are a few videos on sending a mass SMS message through Excel, but is this only done through plug-ins, or is there a way to set it up within one's spreadsheet. If so, please lend me a...
12. ## Thread: IF formula which returns something only if cell is populated

by lzweifel
Replies
2
Views
130

### IF formula which returns something only if cell is populated

Hi again,

I cannot figure out my formula this morning to deliver a formula only if a cell is populated...

If I put a figure in Cell A1, then Cell B1 would deliver the value of 30.00 and Cell...
13. ## Thread: Creating an organizational chart in Excel

by lzweifel
Replies
7
Views
694

### Creating an organizational chart in Excel

Hi everyone.... I am trying to create an organizational chart. What I would like to do is put in one sheet the Role | Rank, etc and have it organize into a chart in another sheet. Any direction on...
14. ## Thread: Conditional formatting for an entire row based on one cell

by lzweifel
Replies
13
Views
926

### Re: Conditional formatting for an entire row based on one cell

Thank you Thank you THANK YOU!!!!!! So very very much appreciated, wish I could buy you a beer!
15. ## Thread: Conditional formatting for an entire row based on one cell

by lzweifel
Replies
13
Views
926

### Re: Conditional formatting for an entire row based on one cell

Now I am all sorts of confused!

I created the dropdown from validation and a list

I can get one cell to change color no problem, but can't get it to change the entire row with it no matter...
16. ## Thread: Conditional formatting for an entire row based on one cell

by lzweifel
Replies
13
Views
926

### Re: Conditional formatting for an entire row based on one cell

Thank you.... May we start over, I am going to highlight my entire sheet and clear all formats.

In Cell A9 to A250 I have a drop down to choose one of three choices:

Closed
Incomplete...
17. ## Thread: Conditional formatting for an entire row based on one cell

by lzweifel
Replies
13
Views
926

### Re: Conditional formatting for an entire row based on one cell

It doesn't work... is it because of the drop down in the cell I am referring to or possibly because I have already put a conditional format in that cell to change the color with the drop down?
18. ## Thread: Conditional formatting for an entire row based on one cell

by lzweifel
Replies
13
Views
926

### Conditional formatting for an entire row based on one cell

I have set A1 with a drop down of four text choices and a conditional format to change the color based on which ever text is chosen. Now, when a certain drop down...

by lzweifel
Replies
2
Views
130

### Excel Tables

Hello,

I would like to compile my data into a table where I can sort more efficiently... the problem I am faced with is that I have two categories, I think... what I am sorting through are parts...
20. ## Thread: Formula to Calculate a Total IF a cell is Blank

by lzweifel
Replies
4
Views
110

### Re: Formula to Calculate a Total IF a cell is Blank

Thank you so much Eric... that worked great. The "=" in your formula.... does that refer to the blank cell... that was the part I couldn't figure out!
21. ## Thread: Formula to Calculate a Total IF a cell is Blank

by lzweifel
Replies
4
Views
110

### Formula to Calculate a Total IF a cell is Blank

Hello All,

I am looking for a formula to calculate the totals of one column IF the cell of another is empty.

I have a table set up to calculate days from Invoice Date to the date those...

by lzweifel
Replies
2
Views
126

### Date formulas

Hi all... can someone help me to calculate out a simple formula... I have a formula which is today's date minus an invoice date to calculate how many days past the invoice date before being paid. ...

by lzweifel
Replies
1
Views
114

### Re: Pivot Table - Reference is Not Valad

I am now getting the error "cannot open pivot table resource" I just need to reference this pivot table and I can't figure out how.

by lzweifel
Replies
1
Views
114

### Pivot Table - Reference is Not Valad

Can I easily re-reference this?

Thank you so much for your time!!
25. ## Thread: Formula to calculate dates in specific cells

by lzweifel
Replies
3
Views
324

### Formula to calculate dates in specific cells

I am trying to create a simple spreadsheet which will tell me when Invoices are due. What I would like to do is enter a date of an invoice and each time I open the spreadsheet based on the current...
Results 1 to 25 of 150
Page 1 of 6 1