=IF question

D

Dick

I have 3 column of numbers, A numbers are all less than the B numbers and C
numbers are A column + .2*A column
I can't get the following to work in my D column
=IF(B1,C1>=B1,C1)
I am not getting error messages I just can't get the values to show up. I
either get a TRUE statement in the cells or a VALUE statement in the cells
Any help is appreciated

Thank you in advance
 
B

Bob I

This statement reads thusly

If cell B1 is not Zero then display the True or False result of cell C1
being equal or greater than cell B1 otherwise display the value of cell C1.

A display of True will result if the cell B1 contains a value greater
than A1 but LESS than or equal to 1.2 times A1 you will get a #value
result from having a "text" number in B1, so please check cell contents
carefully.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top