So, I have values in cells I4 & J4 , and then I have values in K4 & L4
I need to return the value 1 if the sum of the value in I & J = the same as the sum of the value in K & L
Hope that makes sense
So, I have values in cells I4 & J4 , and then I have values in K4 & L4
I need to return the value 1 if the sum of the value in I & J = the same as the sum of the value in K & L
Hope that makes sense
Like this...
=IF(I4+J4=K4+L4,1,"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
yip, that's the one, so simple when you out it like
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks