LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Function explaination need

Previous staff have form the function below and I don't understand what it
means. He was no more longer work here. I need someone to explain what it say.

Here is the function look like
=IF(ISERR(VLOOK($A7, returnall, 32,0)*100) ,€œ €œ,VLOOKUP($A7, returnall,
32,0)*100)

Can anyone also explain why the 32 can be change to any number, what it
represent?

Thanks for anyone trying to help
Cheer,
hoachen
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested formula - seeking explaination mldancing Excel Discussion (Misc queries) 2 March 20th 07 09:04 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Formula explaination r Excel Discussion (Misc queries) 6 May 16th 06 04:12 AM
Offset function with nested match function not finding host ss. MKunert Excel Worksheet Functions 1 March 21st 06 10:46 PM
Emulate Index/Match combo function w/ VBA custom function Spencer Hutton Excel Worksheet Functions 2 May 2nd 05 05:26 PM


All times are GMT +1. The time now is 07:17 AM.

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

About Us

"It's about Microsoft Excel"