Logic Statements

[Guest]

I need a little help with my logic statement. I want for it to display a
"1.0" if the calculation is less than zero and to display the real number if
greater than zero. This is as far as I can get.
Thanks!
=IF((((D12*$O$4)-Y12)/$AB$4)>0,,"1.00")

 

[Bob Phillips]

=IF((((D12*$O$4)-Y12)/$AB$4)>0,"(((D12*$O$4)-Y12)/$AB$4),"1.0")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

That didn't work unfortunately, it just tells me that there is an error with
the formula and wants to add a second set of quotes around "1.0". When I
accept it, it just makes all the values say the word "False".

 

[Guest]

Okay, I fixed that to:
=IF((((D12*$O$4)-Y12)/$AB$4)>0,"(((D12*$O$4)-Y12)/$AB$4),"1.0")
But it changes all my calculations to 1.0 now regardless if it is positive
or negative.

 

[Bob Phillips]

My mistake. Try this

=IF((((D12*$O$4)-Y12)/$AB$4)>0,(((D12*$O$4)-Y12)/$AB$4),"1.0")



--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Darn, now I have two issues. I messed up my sign, it should be less than
zero, not greater than. But if I set it to greater than zero, all the figures
display 1.0. If I change it to less than zero, all the figures come out to be
-1.10.

 

[ehflam]

seems to be all your formulas are giving you the answer -1.10

the formula shown should be correct, check your numbers... or sub in
real numbers to check the formula first..

 

[Guest]

No, the numbers are fine. I have used the same calculation to compute the
numbers before pasting this new formula into the same cell. None of them
equal -1.10.

 

[Bob Phillips]

It works for me mate!

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

My copy of the spreadsheet must've been corrupted. It worked on my other copy.

Thanks for your help.