Forum Discussion
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...
=IF(B3="Low",A3+42,IF(B3="Medium",A3+28,IF(B3="High",A3+14,IF(B3="Yesterday",A3-1,IF(B3="Two weeks ago",A3-14,"")))))Does this return the intended result?
=IF(B3="Low",A3+42,IF(B3="Medium",A3+28,IF(B3="High",A3+14,"")))This is the formula without additional (4th and 5th) criteria.
OliverScheurich Thanks very much, this worked a treat. Really appreciate it.
