have not seen a worse tip ever 🙈🤦 pls stop giving ppl advise with your excel 97 skills from your job in a bank .... 1st how can ppl do it without excel ? 2nd why not get a software for that? so many better ways to do this but this is by far the worst way doing it pla stop giving advice with your anti knowledge THX
I have a question. I have a column of 10 digit numbers. I need to add "B" to the front of all those numbers, then extract that new data to .csv file for upload to another system. What do you recommend?
=IF(A3=0,0,IF(A3<40,A3*$B$1,(40*$B$1)+(A3-40)*($B$1*1.5))) OVERTIME A3=HOURS (A3 is the cell wear hours is input) $B$1=WAGE ($B$1 is wear wage is input. $'s denote a fixed cell so when you transfer formulas to other cells it always pulls info from that same cell)
Who needs all that when you can parse data from a file in python and export it as an excel file! Make more complex by using regular expressions to obtain the data you need!