I have a cell that I want to calculate this if statement
=IF(E7>D7,E7-D7,D7-E7) but only if the Cell G7 is yes.
I wrote this formula
=IF(G7=yes,(IF(E7>D7,E7-D7,D7-E7)),"n/a") but it doesn't work, how would I fix it?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community