Forum Discussion
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...
=IF(OR($C$15="Not Lease", D$21="Past Horizon"), 0, $C$29*$C$3)
That worked, thank you very much! Is there a limit for how many conditions you can add to the IF(OR) formula?
Functions can have up to 255 arguments, so OR(...) could have up to 255 conditions!