![excel if then formula with numbers excel if then formula with numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-26-768x361.png)
In cell E9, the following IFS formula checks 3 cells in an order form, to see if the product name, price and quantity have been entered. In this example, instead of using a nested IF formula, here's an IFS formula. Limit the number of logical tests to just a few, or it will be difficult to build and maintain the IFS formula. Note: Although you can enter up to 127 tests and their related values, Microsoft advises against nesting too many conditions.
![excel if then formula with numbers excel if then formula with numbers](https://exceldesk.in/wp-content/uploads/2019/12/IF-2BFormula-2BValue-2BLimit-2BCalculation.png)
![excel if then formula with numbers excel if then formula with numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-38.png)
![excel if then formula with numbers excel if then formula with numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-52.png)