Help with IF function formula

  • Thread starter Thread starter Mike M.
  • Start date Start date
M

Mike M.

Hi, I can't figure out how to write a formula. It's a long formula
but I'm going to give a very simple example:

Let's say I want to say: "if a1>1, a1+b1, otherwise write less than
a1+b1." So if a1=0 and b1=5 I want the cell C to say <5

=IF(A1>0, (A1+B1), <(A1+B1) doesn't work. I put quotation marks and
that didn't work either.

thanks in advance for your help,

Mike
 
Hi,

Thanks again for making the formula work. But now there is another
problem - I cannot control the number of digits I get after the
decimal point. My formula is as follows: =IF(J14>0,J14/F14,"<"&1/F14)
it works just fine when J14 is greater than 0 and I'm able to increase
or decrease the number of digits after decimal point. But when J14=0
(and for example F14=0.0686) I get <14.5772594752187. I want this
cell to show <14.58. When I get rid of "<"& part in the formula, the
cell shows 14.58.

Please let me know how to fix the problem.

Thank you,
Mike
Los Angeles, CA
 
Back
Top