if fucntion

I am trying to figure out the formula where I need a cell to auto populate a result based on the input of another cell. For example. Column A (Region) will be the cell that will have the input. Column B (Destination Location) is the cell that I would like to auto populate based on the input...

I have a spreadsheet I am working on and I need it to highlight cells depending on data from other cells. Here is an example to make it clearer: I want cell D4 to highlight yellow if the following conditions are met. If B4 is greater than C3 and less than E3 turn D4 yellow. Is it possible to...

Hi All, I need a formula using an if function that add +1 on per $1000 of cell value if exceeds from $10,000 $950 10 $10,000 10 $10,001 11 $11,001 12 Thanks in advance...

I'm having trouble inserting and extra if function at the beginning of my formula. I have a 'Job sheet' which informs my workshop of what to produce based on what has been quoted (information for the job sheet is gathered from another sheet in the same workbook). Currently, I have the...

I'm having trouble inserting and extra if function at the beginning of my formula. I have a 'Job sheet' which informs my workshop of what to produce based on what has been quoted (information for the job sheet is gathered from another sheet in the same worksheet). Currently, I have the...

Hi, I had posted a question for an If formula but i am thinking there might be a way of fixing my issue through VBA? This is my problem : I have a worksheet that will be constantly updated. In D53:CU54 i currently have an IF formula which looks at newly Inserted data in D100:DH101 (Via...

Hi any help would be really appreciated on the following I am trying to add a copy and paste macro into a protected spreadsheet to allow users to copy rows of data. The macro should only run however if the user selects an entire row and in cell A of that column there is the value 1. The...