Feb 23 2024 01:27 PM
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 beyond the Last Year in cell C19. I am trying to have cell D23 calculate the net rent cost if Lease is selected in Cell C15 and Row 21 does not say Past Horizon. If Cell C15 shows Not Lease OR row 21 shows past horizon I want to show a value of $0. I currently only have it set to show a value of $0 if row 21 shows Past Horizon using this formula =IF(D21="Past Horizon",0,$C$29*$C$3) but I can't figure out how to add in the second condition for Lease or Not Lease.
Feb 23 2024 01:57 PM
=IF(OR($C$15="Not Lease", D$21="Past Horizon"), 0, $C$29*$C$3)
Feb 23 2024 03:10 PM
Feb 23 2024 03:17 PM
Functions can have up to 255 arguments, so OR(...) could have up to 255 conditions!