Recent content by FernJones

  1. F

    Solved Help with IF then Roundown formula

    Hi, Thank you so much for your reply and formula! Yes, I'm using Excel. Yes, that was a typo, I should have written $6599. And your formula works great, exactly what I was trying to do. You saved me so much time, I appreciate your help very much! Thanks again and Happy New Year! Fern
  2. F

    Solved Help with IF then Roundown formula

    Hi, I have two cells, cell #1 contains my calculated value, and cell #2 has a formula to round down cell #1 to the nearest 99. This works well when cell #1 and cell #2 are not the same, but when they are the same, it still rounds down but I'd like cell #2 to stay the same as cell #1, and not...
  3. F

    Pivot Table help to calculate # To Sell, # Sold and # Unsold

    Hi, I need some help with a Pivot Table please, so I can avoid manual calculations. I have attached a file which shows my Data, my current Pivot Table and the Pivot Table I'd like to achieve. It's basically # of items in our inventory, # sold, % sold, # unsold and % sold. I have tried to...
  4. F

    Solved Adding a calculated field to a pivot table

    Thank you for the link, it's very useful, and I will study it. I had some other questions on my attachment, but I'll try to figure them out. My best, Fern.
  5. F

    Solved Adding a calculated field to a pivot table

    Hi, I've been playing around with this and can't figure it out... I'd like to add a sold versus capacity percentage (I call it Load Factor) to a pivot table. I have attached my sample file with my notes. Could someone please try to help me out? Thank you so much. Fern.
  6. F

    Solved Calculate difference between two dates

    Hi. Sorry, I did forget to mention that it's Excel I'm using. And thank you so much for the VLOOKUP idea, I didn't even think about that. Your excellent suggestion and will save me so much time every week. I really appreciate your help! Thanks and have a great weekend! Fern.
  7. F

    Solved Calculate difference between two dates

    Hello, I'm trying to save time by creating a formula for something I do every week, and I'm stuck. I wonder if someone would be able to help me out. I have two columns, they each contain a date. I need a formula to subtract Col A from Col B to calculate the difference, then to assign a...
  8. F

    Solved Change currency symbol on several tabs in Excel

    Thank you! I'll just manually re-format them for now. Maybe I'll find another solution in the future. I appreciate your time. Fern
  9. F

    Solved Change currency symbol on several tabs in Excel

    Hi... No, that doesn't work unfortunately. Tried that, and I get a message that Microsoft cannot find a match. The numbers are formatted as Custom. Thanks though for the idea! F.
  10. F

    Solved Change currency symbol on several tabs in Excel

    Hello, I have a file with about 30 tabs and I need to change the currency symbol from C$ to A$ on all tabs in all cells. There is also US currency in my file, but those are indicated as just $. For example: $500 C$600 should be changed to $500 A$600 The columns are not identical...
  11. F

    Solved: Converting custom date format into text

    Hi, Thank you so much for all the replies, I really appreciate your help and time. My file worked great now! All the best, Fern.
  12. F

    Solved: Converting custom date format into text

    Hello, I have a column of dates that I have formatted like this: \S\Ayymmdd The date needs to look like this: SA160327 This is exactly what I need, except I have to insert these in a csv file, and when I try to copy and paste the date, the formatting is gone, and I just get numbers like...
  13. F

    Solved: Need help with Excel formula please

    Wow..... Thank you so much, this is wonderful! You saved me so many hours of work, I really appreciate your help! Thanks and all the best... Fern.
  14. F

    Solved: Need help with Excel formula please

    Hi again... I'm sorry my request wasn't clear. I must have gotten so frustrated that I didn't put my thoughts down correctly. The values I'd like put in C2 don't really matter, I can change those later. It's the IF AND THEN formula I'm having problems with. What I want to calculate with a...
  15. F

    Solved: Need help with Excel formula please

    Here you go... I hope attached the file correctly. Never done it before. And thanks for your help. Fern.
Top