Excell _ if

  • Thread starter Thread starter Victor
  • Start date Start date
V

Victor

I would like to knou if I could aply the command if twice:
=if(I3=1;N5;"NÃO")[if(I3=2;N6;"NÃO")]
why did it not work?
There are 2 conditions to extract:
one in the cell n5=xpo=12? and second n6 to extract
xyz=16?
thanks
 
Try

=IF(I3=1;N5;IFI3=2;N6;"NÃO"))

HTH

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk

I would like to knou if I could aply the command if twice:
=if(I3=1;N5;"NÃO")[if(I3=2;N6;"NÃO")]
why did it not work?
There are 2 conditions to extract:
one in the cell n5=xpo=12? and second n6 to extract
xyz=16?
thanks
 

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

if 1
If function 1
funcion if 1
Return value from column A if match to column D 3
turn a cel a color based o todays date 9
Microsoft Excel Rank and Sort 2
Highlight cell on certain dates 14
Difficult formula! Need help quick! 4

Back
Top