ifs functions

I am not sure if I am over complicating this or not. I have the following set up and while excel is great and accurate I need to figure out how to achieve the result I want. So I have this formula in my size column -...

I need big-time help here! I have altered the formula so many times and have gotten completely confused and still, get an error "The function in the formula causes the result to change each time the spreadsheet is calculated. The final evaluation step will match the result in the cell, but the...

I need to update the below formula to include this piece: IF(AND(Rate_Card_Selection="Company B",C19="Remote Access Points"),0,150)) What is the correct way to nest the IF AND function into the below? =@IFS(C19="Company A (London)",325,Inputs!C19="Remote Access...

I'm sure I'm just missing something in my statement because i get a formula error, but I'm trying to have my Column "i" look at Column "E" which is a date format. Column "i" would return "Expired" if the date is <today(), "Expiring" if the date is between today and 120 days, and "Current" if its...

My goal is to understand which two week increments of a marketing campaign were most/least effective. Column A: live data for a marketing campaign (leads generated) Column B: Sum up the live data up until 2 weeks after the start date of the campaign. After the 2 weeks is complete, I would...

Hello, I have the latest version of excel and created a sheet with a "IFS" formula in one of the sheets. It is a long formula with many if statements. I copied sheet over to another computer only to find out that it was using a older version of office and does not have the functionality. So was...

I was using IFS function to calculate the grades although the formula and result is correct it always show green triangle on the upper left corner of the cell. why so?