conditional logic

I'm very new to Excel formulas and really struggling. I'm creating a spreadsheet which lists items and their specifications. Eg. column A has the item name, B has the size, C has the file type, D is the due date etc. I want to make sure that if people add an item that they fill out ALL the specs...

Hi, first post. I was wondering if I could get help on developing a macro that would add dollar amounts in a range. I’ve looked at formulas but that will not work in this case. In my research i found the following: Conditional Logic in VBA In the most of programming specific sections of...

Hi, I am trying to have a cell show an icon set based on another cells value. The other cell being a percentage value. I have it working... almost. It turns out that the cell I am placing the icon set in is a Unit Price cell (column) which is looking at a cell elsewhere in the workbook. When...

Hi There, I have a table with hospital admission date (column A), discharge date (column B), and a third column that calculates the duration of stay (column C). Sometimes, people forget to enter data for either the admission date (column A), or the discharge date (column B), or both (columns A...