Hi,
I'm seeking assistance with the following:
I'd like to sum two cells, in example, (V7, W7) and compare the result to cell AB7.
If the sum result matches AB7 then value in formula cell should be set to "1", else "0".
Thank you.
Rgds,
Chubs
Hi,
I'm seeking assistance with the following:
I'd like to sum two cells, in example, (V7, W7) and compare the result to cell AB7.
If the sum result matches AB7 then value in formula cell should be set to "1", else "0".
Thank you.
Rgds,
Chubs
Try this:
Cheers,Please Login or Register to view this content.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
=if(V7+w7=AB7,1,0) should do the trick...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Glenn,
A big thank you!
Work perfectly.
Regards,
Chubs
You're welcome. Can you please mark the thread as solved and maybe say thanks to those who helped by clicking the Add Reputation button at the foot of their posts?
Thanks also to ConneXionLost!
Most appreciative of your feedback.
All the best,
Chubs
Cheers! Any time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks