Utilizzo della formula SOMMA PIU' SE
buonasera a tutti mi chiamo alessandro e sono alle prime armi con excel. in allegato ho messo copia del file al quale sto lavorando sto creando una tabella per tener traccia in base al: personale coinvolto data del servizio inizio e fine orario servizio motivo causale utilizzando la formula somma più se non mi tornano i conti es. 6 volontari di servizio assieme per la stesso motivo e stessa causale ma,da come vedo per il risultato,mi conta come se fosse solo uno che lo svogle. dove sbaglio?data validation
Hello Everyone, I am preparing an error log sheet, in that, I used a custom data validation in D column =AND($C$3<>1,$E$3<>1). just checking C column value is not equal to 1 and E column is not equal to 1 then it should allow entering in the D column. It is working properly if I used as a formula but allowing to enter the value when I used in data validation. Please help
Help setting up a a spread sheet to help my semi retired Dad
I need help! My Dads hobby is costing him money I would really appreciate some advice on a spreadsheet I’m working on So my Dad grows plants and makes garden furniture and sells them which is great however, he has actually been selling stuff at a massive loss. So I have created a sheet where: cell 1 cost price cell 2 vat % cell 3 vat cost cell 4 mark up ((c1+c3)+a percentage of the result of c1+c3) cell 5 retail price (c1+c3+c4) I am trying to make it so the mark up can be a selection drop down of a percentage of 5% increments so when he sells something a friend he can select for eg: 0% to a neighbour say 15% and if he does a market eg 100% but I am not very good at excelling Can anyone point me in the right direction? Many thanks Ace___
Help with copying word data to match excel format
Hello, I am trying to find a way that I can copy data from a word file and have it match the layout setup in the excel file I am pasting to all at one time. So far I have used paste transpose, but it still is causing me to select one persons data to paste at a time otherwise all of the data is moved from a column into a single row. I want it where the data for one person will fill in the columns in a certain row in excel and then automatically move the next set of data to the next row. Is this possible to do?
Marketing Lists
Hi all, I have multiple .csv files with a lot of email addresses that I would like copy and paste into an email which I have done in the past many times and my email recognizes that it is multiple email addresses and automatically separates them, that is not happening anymore and I don't know how to fix it. Suggestions? Thanks so much!
