Here are some problems that our users have asked and received explanations on
I need to have a cell turn color based on the number of times an inventory item is scanned. If a the item is scanned an even number of times its green. If an odd number of times its even. I know I could get this with conditional formatting rules. The trick is I have to combine this with VLookup.
Solved by A. J. in 30 mins
Struggling with understanding the why and finding an example of an application for XOR in Excel with 3 or more conditions and why an odd number = true and an even number = false. There are plenty of explanations with two conditions and I get that but what I can't seem to find is anyone to say WHY it is true for an odd number and why false for an even when there are more than 2 conditions... HELP!!
Solved by I. A. in 22 mins
Can you create an if statement to return a number with a maximum value. Even if the percentage is over 100%
Solved by E. W. in 25 mins
I have a logical number and i want to have an output of 1 if all cell are 1 and if there is a zero on any of those cell output should be zero.
Solved by Z. W. in 25 mins
This statement doesn't seem to be working. It comes back as zero, even when G32 is not "0"