How to compare the sum of two cells in an expression column with a user input value???

[#1]

I was trying to compare the sum of two cells in a an expression column which is defined as(vSum=(sum(A)/1000=sum(B)/1000) and these two cells corresponds to the  'Category_1' and 'Category_2'  text in the dimension column.

Is there any way to resolve this scenario???

[jagan]

Hi,

Try like this

=If(vInputValue1 > Sum(EstimatedHours) AND vInputValue2 > Sum(EstimatedHours), WHITE(), RGB(255, 128, 0))

Regards,

jagan.

[#3]

=If($(vInoutBox1) > $(vSum) AND Match(A, 'Category_1', 'Category_2')),RGB(255,155,0),

If($(vAMPT)< $(vSum) AND Match(A, 'Category_1', 'Category_2')),RGB(255, 0, 0),if($(vInputBox2) > $(vSum) and $(vAMPT) > $(vSum),white())  ))

Does this gives the desired output...I need the Estimated Hours Cell pertaining to Categoory_1 and Category_2 to be in white when both the input box value is greater than the Estimated Hours Value

[jagan]

Hi,

Try this

=If($(vInoutBox1) > $(vSum) AND Match(A, 'Category_1', 'Category_2')),RGB(255,155,0),

If($(vAMPT)< $(vSum) AND Match(A, 'Category_1', 'Category_2')),RGB(255, 0, 0),if($(vInputBox2) > $(vSum) and $(vAMPT) > $(vSum) AND Match(A, 'Category_1', 'Category_2'),white())  ))

Regards,

Jagan.

[#5 · Accepted solution]

Thank You Jagan...infarct it worked but with a little modification!!!

=if(($(vInputBox2) > $(vSum) and $(vInputBox2) > $(vSum) AND Match(A, 'Category_1', 'Category_2')),white(), 

If(($(vInputBox1) > $(vSum) AND Match(A, 'Category_1', 'Category_2')),RGB(255,155,0),

If($(vInputBox2)< $(vSum) AND Match(A, 'Category_1', 'Category_2'),RGB(255, 0, 0))))