=if function

Greetings, im trying to achieve a single function where the following happens: =IF(M3<30, "30 Days or less","" =IF(M3>=31<=60, "30 to 60 days" =IF(M3>=61<=90, "60 to 90 days" So essentially, I'm looking at a bunch of resources where i want to see when their contract is due and separate it...

🤓 Good day my fellow nerds, I need help so I came here to see what Master Nerd could be so kind to solve this issue I am having. What I am trying to do: Using VBA, I would like to pull text from one cell to another based on a Start Date. Example: Text in Cell B11 is "Feed them cheap...

I need a conditional format- the one I know will not work :( Here is what I need: IF i8 says "beaumont" then I need the numbers in L8 to copy over into T8 another example If i11 contains "Ocala" I need the numbers that are put into L11 to copy over into T11 Tried this and it does not work...

I am trying to write an IF formula to look @ 2 cells and then return a text result however both of those cells contain a formula referencing another sheet. The 2 cells I am trying to reference have VLOOKUP's I am using to draw from other data sets. I am trying to work out if the Pref hours...

Hello. I use this board a lot to get answers to my questions but this is my first post so please let me know if I miss anything important. I am trying to calculate some payroll figures and running into some trouble. I know this is a task that seems redundant, well it is, but we are working...

Hi there, I am trying to create an estimate tracker which would allow a user to select their estimator initials from the data validation-list in column C, which once selected would generate the quote number in the previous column B (rows 12 down). Catch is, I'm really new to this and I would...

Hi, I'm after some help please. I have 4 columns with amounts and #N/A in them and a column next to in showing the Min. I want to highlight the Min amount from those 4 columns. Column K to N is where I want to highlight the Min --- column O is the Min...

Complicated one which is why I am struggling and cant seem to get other suggesstions on this topic to work. Situation I have a map of the UK split into 36 zones displayed by 36 freeform shapes on my worksheet. I have a list of 14 teams in a table next to the image to which the zones will be...