Hi,
how could I make a formula where I obtain a solution in another cell?
For example, I have this data:
A B
4 7
and I put in C2 a formula where I say that if the result of add A2 to B2 is 11 I want in D4 the number 15. How could I make it?
I wrote this:
=if(A2+B2=11;D4=15;0)
but it doesn't work.
Thank you very much
Bookmarks