ExcelBanter - Problem with link

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Problem with link (https://www.excelbanter.com/excel-worksheet-functions/65079-problem-link.html)

Runar

Problem with link

How do ya link to functions together ?

Like this:

=if(b1=1;b1*9;b1*4) if(b1=2;b1*8;b1*4)

How do u link these together ??

Pete

Problem with link

Try this:

=IF(B1=1,B1*9,IF(B1=2,B1*8,B1*4))

Pete

All times are GMT +1. The time now is 07:46 AM.