Forum Discussion
Solved
using cell reference instead of cell contents Help
Hi Excel gurus, any chance you can assist a newbie like me to find a good formula to replace this with cell reference instead of using the actual number thats in the cell as the number will vary from...
Not with the match function. You could use nested if functions (say your values are in A1, B2, C3, and D4):
=IF(D4<=D10, S10, IF(C3<=D10, P10, IF(B2<=D10, M10, IF(A1<=D10, H10, NA()))))*D10Or, if you have the IFS function, you could try:
=IFS(D4<=D10, S10, C3<=D10, P10, B2<=D10, M10, A1<=D10, H10, True, NA())*D10
HI JMB many thanks for your reply, does this still count if the cells are not next or grouped together, i.e could you use $A$1 + $B$2$ for instance....
Not with the match function. You could use nested if functions (say your values are in A1, B2, C3, and D4):
=IF(D4<=D10, S10, IF(C3<=D10, P10, IF(B2<=D10, M10, IF(A1<=D10, H10, NA()))))*D10
Or, if you have the IFS function, you could try:
=IFS(D4<=D10, S10, C3<=D10, P10, B2<=D10, M10, A1<=D10, H10, True, NA())*D10
- Hi JMB,
Wow thanks for this it is very much appreciated works a treat, just made my day.
Regards