Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function giving Error
Hi,
I am Using Office XP and i am writing a function in Excel that is giving me an error "The formula you type contains an error...." here is my function =IF(B20="Semiprecious",VLOOKUP(ROUND(RAND()*100,0) ,semiprecious,2),IF(B20="Fancy",VLOOKUP(ROUND(RAND ()*100,0),fancy,2),IF(B20="Precious",VLOOKUP(ROUND (RAND()*100,0),precious,2),IF(B20="Gems",VLOOKUP(R OUND(RAND()*100,0),gem,2),IF(B20="Jewels",VLOOKUP( ROUND(RAND()*100,0),jewel,2),IF(B20="Ornamental",V LOOKUP(ROUND(RAND()*100,0),ornamental,2))))))) The problem seem to be the last round(rand... function. If i remove the last ROUND it work fine but when i put it in i am getting the error. Is there a limitation with the number of function you can have in a single cell ? Any help greatly appreciated Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom function returning VALUE error | Excel Discussion (Misc queries) | |||
@ and "function not valid" error (Excel 2003) | New Users to Excel | |||
#Name? Error in User Defined VB Function | Excel Worksheet Functions | |||
Nested IF AND OR function Inexplicable error | Excel Worksheet Functions | |||
Why do I get a #Name error when I use the DateDif function? | Excel Worksheet Functions |