Forum Discussion
JustHelen
Oct 31, 2023Copper Contributor
Using 2 IF formulas
I'm trying to get 2 IF formulas to work on a financial spreadsheet but can't seem to get it right. Column M has a Yes/No dropdown. If Yes is selected i need N2 to calculate O2 - L2. If No is selected...
- Oct 31, 2023
=IF(M2="yes",O2-L2,"0.00")
SanthoshKunder
Oct 31, 2023Iron Contributor
=IF(M2="yes",O2-L2,"0.00")
- JustHelenOct 31, 2023Copper ContributorThank you so much!