How JustAnswer Works:
• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
Ask The-PC-Guy Your Own Question
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1948
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# New Question: Its a "hard wired" conditional formula. Should

This answer was rated:
New Question: Its a "hard wired" conditional formula. Should be fairly simple, but I'm still having difficulty with it. (I must be tired or something. LOL)

I want the formula to say:

If 0<=B23<=99,999.99, then return .25 in B24;
If 100,000<B23<199,999.99, then return .50 in B24;
If 200,000<B23<299,999.99, then return .75 in B24;
If 300,000<B23<399,999.99, then return 1.00 in B24.

The-PC-Guy :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

The-PC-Guy :

so you want to check if B23 is between those various ranges and use the appropriate matching value

Customer:

exactly. check to see what range b23 falls in, then assign a corresponding value to b24.

The-PC-Guy :

ok

The-PC-Guy :

give me a minute to do that

The-PC-Guy :

i set up an example sheet that has the formula you need

The-PC-Guy :

you can download it from here.

Customer:

ok hang on....

The-PC-Guy :

let me know if you have any problems with that file

The-PC-Guy :

otherwise rate when ready

The-PC-Guy :

thanks

Customer:

That's the one.... thanks Andrew. You're da bom!! :)

The-PC-Guy and 3 other Microsoft Office Specialists are ready to help you