Forum Discussion
Boris_0031
Aug 24, 2023Copper Contributor
Adding a 3rd condition to "IF" formula in Excel
Hi all, I hope some kind soul out there can help me. I am working on a tight deadline for work, which is an excel sheet where I have managed to successfully create a formula for “if” with 2 conditi...
SergeiBaklan
Aug 24, 2023MVP
As variant
=A3 + LOOKUP(B3, {"High","Low","Medium","Two weeks ago","Yesterday"}, {42,14,28,-14,-1} )
Even better is to build helper table with criteria/delays and XLOOKUP/VLOOKUP, etc., on it.
Boris_0031
Aug 25, 2023Copper Contributor
Thanks very much. I'll definitely check out some YouTube vids on this this weekend. Much appreciated.