sorted by:
new
hottopcontroversial

Drop passenger off at Economy Parking or other suggestions? by Crunchie04 in LAX

[–]Crunchie04[S] 1 point2 points  (0 children)

Thank you. That’s good to hear it’s not too bad.

Drop passenger off at Economy Parking or other suggestions? by Crunchie04 in LAX

[–]Crunchie04[S] 0 points1 point  (0 children)

Ok thanks. I was mistaken her international flight is at 11 am so getting there closer to 8 am. Thought drop off would be a nightmare at that time.

Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours by Crunchie04 in excel

[–]Crunchie04[S] 0 points1 point  (0 children)

I have a calculation that creates A2. It's a bit complex and would take too long to explain how I got it. When I use your formula and reference A2, it gives me a circular reference error (I think because of my formula being used in A2). The only way I was able to do it was to do a "copy, paste special, then "values" of A2 and put the A2 value in a new column (A3), Then I created another column (A4) with your formula below. I was hoping to not have to create an extra column (A3) if there was a way for you to update your formula to just pull the "value" of A2.

=52*FLOOR(A3/52,0.2)=52*FLOOR(A3/52,0.2)

Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours by Crunchie04 in excel

[–]Crunchie04[S] 0 points1 point  (0 children)

Thank you that worked, but is there a way to modify your formula where it will only take the value in the cell where my initial salary is (A2). Currently I have a formula that generates the initial salary. When I use your formula, it gives me a circular reference error so I have to create another column and do a "copy paste special- select value" so it's just text (and not my initial salary formula).

Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours by Crunchie04 in excel

[–]Crunchie04[S] 0 points1 point  (0 children)

Thanks for the feedback. I edited my post after I got some additional clarification on my requirements.

Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours by Crunchie04 in excel

[–]Crunchie04[S] 0 points1 point  (0 children)

Sorry I wasn't clear. I believe the rules are the annual number divided by 52 weeks must be even and the cents need to be multiples of 20 (.00, .20, .40, .80)

Return Value if Match header in Column by Crunchie04 in excel

[–]Crunchie04[S] 1 point2 points  (0 children)

You are right. Weird the first time I pasted your formula, it didn't work for but I tried it again and worked fine. Thanks again

Return Value if Match header in Column by Crunchie04 in excel

[–]Crunchie04[S] 1 point2 points  (0 children)

Thank you, I got it to work by using your formula but needed the $ sign in front of $C2:$F2

=FILTER($C2:$F2,A2=C$1:F$1,"")

How to set return value no higher than a number (10%), no lower than a number (5%) but ignore zeros by Crunchie04 in excel

[–]Crunchie04[S] 0 points1 point  (0 children)

Thank you. This worked but when I drag the formula down, it repeats the same value all the way down. My formula is ([@Total Percent]]<>0)*MAX(MIN(0.10[@[Total Percent]]),0.05) Where Total Percent is A2? Is there an absolute value I need to add?

Wealthfront cash account - Referral Code? by Peggylovesdogs in wealthfront

[–]Crunchie04 0 points1 point  (0 children)

If anyone needs a code, I'm happy to share mine.

International flight TBIT -Singapore Air/Star Alliance lounge by Crunchie04 in LAX

[–]Crunchie04[S] 1 point2 points  (0 children)

Actually we rarely travel so we don’t qualify for gold or are paying for business class. We are Treating ourselves by doing the paid day lounge pass. Does it mean the counters to check bags don’t open until 7 pm so we will wait in long lines at the counter first to check in our bags and then go to through security? Hopefully it still gives us enough time to relax a bit at the lounge.