i need a multi-if function for my excel worksheet, any ideas how to do it?
thanks very much
i need a multi-if function for my excel worksheet, any ideas how to do it?
thanks very much
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" <[email protected]> wrote in message
news:[email protected]...
>i need a multi-if function for my excel worksheet, any ideas how to do it?
>
> thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks