What i want to do is if Sheet2!C4 = Sheet1!C1 then Sheet2!F3 should calculate Sheet2!B2+Sheet1!G2
What i want to do is if Sheet2!C4 = Sheet1!C1 then Sheet2!F3 should calculate Sheet2!B2+Sheet1!G2
Welcome to the Forum!
Your thread title isn't very good but since it's your first post and a simple question I am going to answer it if you promise to review our rules. There aren't many, and they are all important. Rule #1 requires good titles.
In cell Sheet2!F3 put this formula:
=IF(Sheet2!C4 = Sheet1!C1, Sheet2!B2+Sheet1!G2, "?")
The ? is what you will get if the equality is not true. What do you want to do in that case?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks