Multi-If function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 Windows 10 can't find scanner (part of an multi-function printer) 6
Emailing worksheet 2
Multiple sheet querries 4
If then 8
Firefox Multi-Account Containers 1
Multi-Region? 1
MIN and Year Functions 3
Multiple function queries in same cell 2

Back
Top