Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multi-If function
i need a multi-if function for my excel worksheet, any ideas how to do it?
thanks very much |
#2
|
|||
|
|||
Hi Stefano
a few more details would have allowed us to give a more detailed answer but the general syntax of a nested IF function is =IF(test,IF(test,true,false),IF(test,true,false) where there is an IF nested in both the true and the false sections of the original IF. Note, you can only nest up to 7 levels. An alternative to the IF function is the VLOOKUP function. if you would like more assistance please provide additional details. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Stefano" wrote in message ... i need a multi-if function for my excel worksheet, any ideas how to do it? thanks very much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
How do I create a multi formula IF function in Excel? | Excel Worksheet Functions |