Thread: [Solved] 2nd matrix gives a resut that doesn´t match numbers in the 1st matrix
View Single Post
 
Old 02-20-2017, 02:36 AM
Diver Diver is offline Windows 10 Office 2013
Novice
  
Join Date: Feb 2017
Posts: 21
Diver is on a distinguished road
Default
B2 = 15 and G2 = 20 then J2 has to come back C
B2 = 20 and G2 = 50 then J2 will come back D
B2 = 225 and G2 = 225 then J2 has to come back with a error

If B2+G2 does not come back as a number that exists in column B. it has to choose a number higher than it self in column B.

Example B2 = 50 and G2 = 50 then I2 = 100 but it has to choose 105 from column B or J2 has to choose H from column D
Reply With Quote