SOLVED

Using 2 IF formulas

Copper Contributor

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?

3 Replies

=IF(M2="yes",O2-L2,"0")

best response confirmed by JustHelen (Copper Contributor)
Solution

@JustHelen 

=IF(M2="yes",O2-L2,"0.00")
Thank you so much!
1 best response

Accepted Solutions
best response confirmed by JustHelen (Copper Contributor)
Solution

@JustHelen 

=IF(M2="yes",O2-L2,"0.00")

View solution in original post