IF statement with FALSE value being text AND cell reference?

J

jcob2

I want my FALSE statement to have a "<" infront of the number reference
by the calculation, and don't know how to make the FALSE have text an
an equation.

=IF(D9>1,(D9*D8),"<"(D9*D10))

I can get my FALSE to have just a < sign if I do this:
=IF(D9>1,(D9*D10),"<")

I can get my FALSE to have the number calculated by the equation if
do this:
=IF(D9>1,(D9*D8),(D9*D10))

But how come I can't get it to read "<"(#value) by using the firs
equation listed above?

Thanks for the help in advance
 

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

Similar Threads

Conditional formatting a whole column but with the conditions < & 1
IF statement query 2
how to count this in this unusual situation 2
Data Entry Form: Complex Example 4
Help with If formula 6
Still having problems with If --Elseif 13
using a IF statement to return a value 2
Run macro if cell value changes 2

Top