PLease assit me with an IF then statement.

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.

Try it like this:

=IF(A1=>1,0,B1)

Format the cell as percentage.

Hope this helps.

Pete

Very close. Just take the second equals sign out -

Formula:

Please Login or Register  to view this content.

You may also need to format C as a percentage

Perfect. thank you everyone. cant believe i couldnt do something so simple.

Reps given

I did. Well spotted