-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
determines
-
G
Combine Nested Funtions
Need help combing these function into a single cell This formula recalculates the date based off a value in column P =IF(OR(P16="A - Svcbl(w/o Qual)",P16=""),(AM16+450),(AM16+90)) This formula determines the amount of days between today and the new date =ABS(AN16-TODAY()) This formula enters...- gleichmang
- Thread
- based calculating combine current date determines formula insp overdue svcblw/o
- Replies: 8
- Forum: Excel Questions
-
N
Use excel value to determine the VBA Offset parameter
I have this little line of code: Selection.Offset(-1, 0).Select Now the -1 here needs to be variable, it could be either -1 or -2. I have a cell whose value determines that. How do I implement that into the code?- Nachtschade
- Thread
- cell code determines implement variable
- Replies: 2
- Forum: Excel Questions
-
J
Combining IF with different Vlookup arrays
I have looked at other suggestions for using vlookup within an if statement. I have tried the following formula without success. C3 is a drop down list which determines which array I want to use. =IF($C$3=“Standard”,VLOOKUP(A7,Inputs!$H$5:$J$47,3,FALSE),vlookup(a7,Inputs!$L$5:$N$47,3...- Jjagz
- Thread
- array determines formula list vlookup
- Replies: 9
- Forum: Excel Questions
