If statement using greater than and less than within ranges.

I have an IF formula with less than and greater than within ranges but can not get the formula correct when a negative number is generated:

Cell A1= .342

My formula in B1 is =IF($A1>0<=0.34,$A1,IF($A1>0.34,($A1-0.67),IF(B1<0,$A1)))

How can I get B1 to return A1 if a negative number is generated by the second condition in the IF statement.

Thanks Gene

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Answer

Hi,

Maybe this in B1

=IF(AND($A1>0,A1<=0.34),$A1,IF(AND($A1>0.34,$A1-0.67>0),$A1-0.67,A1))

If this post answers your question, please mark it as the Answer.
Mike H

If this response answers your question then please mark as answer.

Mike H

5 people found this reply helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Replies (7)

Last updated June 3, 2024 Views 19,148 Applies to: