CMoHorn

Junior Member

Posts: 3

Quote:

Originally Posted by Spencer101

Would the VLOOKUP values always be whole numbers or could they be decimals too?

If always whole numbers then a simple VLOOKUP table would work.

If decimals then a long winded IF AND nested formula would be needed.

Spencer, thanks for the reply. The value would always be a whole number. I'm not exactly sure how to use the VLOOKUP table in the formula above though.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to reconcile numbers accounting Harlan Grove code doesn't work for negative numbers	[email protected]	Excel Programming	1	July 28th 06 07:09 AM
Excel Formula - Add column of numbers but ignore negative numbers	view for Distribution List members	Excel Worksheet Functions	1	April 7th 06 03:13 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Excel Worksheet Functions	3	January 19th 06 09:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Excel Worksheet Functions	1	January 9th 06 01:23 PM

All times are GMT +1. The time now is 12:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us