Need help with an excel formula

Heeter

Overclocked Like A Mother
Joined
8 Jul 2002
Messages
2,732
Hi all,

I am having trouble creating a formula for an excel spreadsheet that I am working on.

Here goes. I would like to input a number into cell AK-26, this value is anything between 70-90 & 485-620. If I input this value into that cell, then I would like the word "ACCEPT" to show up in cell AP-26.

If there is any other number outside those two ranges mentioned above that is inputed into AK-26, then I would like the word "REJECT" to show up in cell AP-26.

If AK-26 is left blank, then nothing is going to show up in AP-26.

Hopefully someone knows enough of this that can help me.

Thanks.
 

falconguard

Carbon based lifeform
Political Access
Joined
11 Feb 2004
Messages
3,406
Create a conditional format, Format>conditional format and select the conditions and enther the ranges. In the Format Cell dialog box, enter teh format you wnat the cell to take when the condition is met.
 

ming

OSNN Advanced
Joined
17 Jun 2003
Messages
4,252
er... Well, I've come up with a formula for your question. Not 100% sure it's correct, but I did spend quite a bit or time trying to figure out where the "IF", "AND", "OR" logical tests fit in with each other.

Here's what I've come up with (see pic). I'd suggest you change the cell numbers in the formula to fit your requirements.
 

Attachments

  • Excel formula.jpg
    Excel formula.jpg
    31.3 KB · Views: 99
  • Excel formula2.jpg
    Excel formula2.jpg
    31.8 KB · Views: 86
Last edited:

Heeter

Overclocked Like A Mother
Joined
8 Jul 2002
Messages
2,732
Awesome, Ming,

Thanks a whole bunch for your help, That did it.

Thanks again,

Heeter
 

ming

OSNN Advanced
Joined
17 Jun 2003
Messages
4,252
No probs, mate.

It gave me something to think about. Now we both know a bit more about how to use formulaes in excel. :p
 

Members online

No members online now.

Latest profile posts

hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!

Forum statistics

Threads
61,999
Messages
673,424
Members
5,592
Latest member
Rhilani