Forum Discussion
Mike_39
Feb 23, 2024Copper Contributor
Excel Perform Calculation Based on Two Criteria Being Met
I am trying to have excel calculate net rent across multiple years. Cell C15 is a drop down where you can select Lease or Not Lease. Row 21 brings back a value of Past Horizon if the column is beyo...
Mike_39
Feb 23, 2024Copper Contributor
That worked, thank you very much! Is there a limit for how many conditions you can add to the IF(OR) formula?
HansVogelaar
Feb 23, 2024MVP
Functions can have up to 255 arguments, so OR(...) could have up to 255 conditions!