# Microsoft Excel Help with Text Formula

**URL:** <https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632>\
**Category:** NYSpeed Off Topic\
**Created:** [May 21, 2007, 12:46pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632 "2007-05-21T12:46:17Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\
**Post date:** [May 21, 2007, 1:24pm UTC](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632/9 "2007-05-21T13:24:10Z")

</div>

[quote=“SilverGT,post:6,topic:29632"”]

=IF(A2=“Davolio”,“OK”, “Not OK”)  
this is a similar formula but i have a list of 30 items has to compare it to, and then return the part number that corresponds to the 30 items it has to compare it too.

[/quote]

[quote=“SilverGT,post:7,topic:29632"”]

=IF(A4\>89,“A”,IF(A4\>79,“B”, IF(A4\>69,“C”,IF(A4\>59,“D”,“F”))))  
i found the formula let seee if it works.

[/quote]

you can’t next 30 items please don’t waste your time. Excell unfortunately has a formula limit… at least 2003 does… 2007 may not … I know 2003 had limits for cell amounts 2007 seriously didn’t seem like it did… so this may be true for the if statements to

I really don’t know what you are doing sooo making a forumula idk… more info… i could paste the formula for you

---

_[View the full topic](https://forums.speedlife.net/t/microsoft-excel-help-with-text-formula/29632)._