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!
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...
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...
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.
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!
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...
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...
I have a column of dates that I have formatted like this:
The date needs to look like this:
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...
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...