Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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. 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. 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. 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. 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.

    Thanks in advance,

    L
  6. 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. Re: Conditional formatting for an entire row based on one cell

    Hi... can you send me the link again to do this?
  8. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. Conditional formatting for an entire row based on one cell

    Hi... please someone help!!

    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...
  19. Thread: Excel Tables

    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. 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. 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...
  22. Thread: Date formulas

    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. ...
  23. 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.
  24. Replies
    1
    Views
    114

    Pivot Table - Reference is Not Valad

    Can I easily re-reference this?

    Thank you so much for your time!!
  25. 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 2 3 4