MrExcel Publishing
Your One Stop for Excel Tips & Solutions

UNDER OVER EQUAL


Posted by Al P. on January 02, 2001 5:42 PM

I have an amount of dollars in B6 and C6, what I need in D6 is a formula to tell me if C6 is more than, less than or equal to B6.

Thanks in advance Al


Posted by Aladin Akyurek on January 02, 2001 6:15 PM

D6 =IF(C6>B6,"More",IF(C6<B6,"Less","Equal"))

Aladin

Posted by Aladin Akyurek on January 02, 2001 6:18 PM

It should be: =if(c6>b6,"More",if(c6<b6,"Less","Equal"))

Aladin

Posted by Aladin Akyurek on January 02, 2001 6:22 PM

I don't what is happening. It seems impossible to post such a simple formula. It gets all mixed up after submitting.

Aladin

Posted by Bruce on January 02, 2001 7:40 PM

Al - Try this

=if(B6>C6,"More",if(B6<C6,"Less",if(B6=C6,"Equal","Error")))

Posted by Bruce on January 02, 2001 7:41 PM

Al - Try this

=if(B6>C6,"More",if(B6<C6,"Less",if(B6=C6,"Equal","Error")))

Something is wrong when sending this.

Posted by MrExcel on January 03, 2001 6:10 AM

Re: Special Characters

The browser is interpreting the less than sign as the beginning of an HTML tag. I apologize that you need to know a little HTML to post such a simple answer.

The formula Aladin was trying to post was:
=IF(C6>B6,"More",IF(C6 < B6,"Less","Equal"))

There does not actually appear to be a way to post a less than sign on the board. Even if you use the Amperand-L-T-Semicolon special character code, WWWBoard changes it to a < on the way in, and then the message does not appear correctly. Do any HTML gurus out there have a solution?