IF FUNCTION IN EXCEL

[Innecco]

Hi guys,

Maybe this will sound stupid, but I am having a lot of trouble to get this functions working.

I would like to have something like this:

IF(50000<E17<100001, E178E18,0)

In words:

If E17 is greater than 50000 AND lower than 100001, then multiply E17 * E18, and if E17 is not within that range ... result should be 0)

Can anyone help????

Thanks

 

[Wray69]

an if and formula would work for you want, this here should work...

=if(and(e17>50000,e17<100001),e17*e18,0)

Regards -

Wray

 

[Innecco]

Thanks a lot.

I ended up doing it with

=IF(F39<100001,IF(F39>50000,F39*F29,0),0)

But the one you mentioned makes more sense.

Thanks again

Leo