#1   Report Post  
Genie Bohn
 
Posts: n/a
Default Is this possible ?

Is this possible?

I want to compare a number against 3 ranges and display a comment for the
range it fits into.

Example.

Let's say the number is 6

<4 - would display no comment

between 5 and 15 - would display the comments "standard"

15 would display no comment.


This is only one line of comparison. Moving down the worksheet the next
example might look like this.

Let's say the number is 147

<80 - would display no comment

between 81 and 125 - would display no comment

125 would display the comment "below standard"


I am very new at vlookup and no nothing of nested functions.

Any help would be graciously appreciated. TIA


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"