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 i need N2 to return 0.00. Can anyone help please?
=IF(M2="yes",O2-L2,"0.00")