IF Forumla for range of specified values_return specified value

Perhaps:

Please Login or Register  to view this content.

Originally Posted by floricita

I will need to adapt the forumla for the actual numbers

In which case I'd suggest posting an accurate example in the first instance.

Originally Posted by floricita

with a slight variation at the end

which would be ?

Originally Posted by floricita

Would it be possible to have a formula that looks up the value in col 1, then looks that value up in col 1 of the look up table (series of ranges), then if that number is within that range, return the value in col 2 of the look up table?

Yes, see VLOOKUP though you would only detail the lower boundary number in Col 1 (10, 751 etc...) and you would list them small -> large - this assumes the boundaries are contiguous of course.

You can use a table as outlined or given A to W output you can use:

Please Login or Register  to view this content.

the choice as they say is yours but the 2 column table offers more flexibility

In Excel, the N function converts a value to a number.

The syntax for the N function is:

N( value )

value is a value to convert to a number.



Note:

•If value is a number, the N function returns a number.
•If value is a date, the N function returns the date as a serial number.
•If value is TRUE, the N function will return 1.
•If value is FALSE, the N function will return 0.
•If value is an error, the error value is returned.
•For all other values, the N function will return 0.

be sure to check out the other Function via Help also - they (help files) are a good resource (most of the time!)