Hi,

Basically i have cells that already have values based on formulas that have been placed.

What i need to do is compare the two cells and come out with a value. The values in B1 are in percentage form. The values in A1 are numbers.

values are in A1 and B1. The outcome must reflect in C1

What i need to test is: IF A1=or >1 then C1 must reflect 0%. IF not then the value in B1 must reflect in C1?

I've tried this formula but its not working. =IF(A1=>1,0%,=b1)
im not sure where im going wrong.

As you've guessed im an excel noob.

Thanks for the assist.