1. ### Pictures in Excel

Hi I'm using Office 2019 on a Windows 10 64bit PC. Is there a way to insert a picture into a cell in Excel, please? I know I can insert a picture into a spreadsheet but I want it to be within the cell so the the cells to the right can relate to it - for example, if I was inserting a picture...
2. ### Solved SUMIFS help

I need help coming up with an excel formula I'm not sure if I need a SUMIF, SUMIFS or some other formula. Each patient is assigned codes (B2:E2) and each code has a value (A5:B11). I need to add up the total value for each patient. The example below only gives a total of one code (in C2)...
3. ### Emailing from Excel

hi guys ive scoured the net and this is as close to the answer i need hope you guys can help. I am looking to have excel filled out with the following: name.......start date..........due date but then somehow vba this to email outlook say 2 days prior to the due date to remind staff to complete...
4. ### Solved IF Statement

Hi there, I can't figure out how to properly write an IF statement for this specific scenario. I have to calculate E.I (Employment Insurance). E.I is 1.27% of your gross income. If my annual gross income is for example \$66'000 I'd type in the formula =(C7*1.27)/100 (C7 is the cell with...
5. ### Simple interactive Excel spreadsheet

I'm trying to create a simple interactive spreadsheet for a club that I run in a local school. We sell food at this club and, because children inevitably lose money throughout the day, their parents have sent us funds in advance. We are therefore looking at the simplest way of keeping track of...