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?
