Hello, I'm trying to do the following functtion
=IF(AND(F2="YES",G2="YES"),"YES", "NO")
but "No" should be displayed only if C2>0 otherwise it should be "N/A" or empty cell.
Could someone help please?
Hello, I'm trying to do the following functtion
=IF(AND(F2="YES",G2="YES"),"YES", "NO")
but "No" should be displayed only if C2>0 otherwise it should be "N/A" or empty cell.
Could someone help please?
Re: IF not
I'm not sure I fully understand the entire logical structure you are attempting, however, you can nest IF statements to achieve the result you describe.
=IF(AND(F2="YES",G2="YES"),"YES",IF(C2>0, "NO",""))
This statement will first evaluate whether F2 and G2 are = "YES". If both are = "YES" then "YES" will be displayed, regardless of the value in C2. If the first condition returns a FALSE (i.e. if either F2 or G2 are not "YES") then the next condition will be evaluated. The next condition, in this case, is whether or not the value of C2 is greater than 0. If this is true, a "NO" will be displayed, else an empty cell will be displayed.
Re: IF not
Thank you so much - that's exactly what I wanted - I appreciate it.
Re: IF not
Please read the Forum Rules and use more meaningful Thread Titles in future.
Don’t have an account yet? Register yourself now and be a part of our community!