Get instant live expert help on How do I is zero an even number

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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" =IF(G32= "0",D32*O32,G32*O32)
Solved by M. W. in 28 mins