Excel's IF function

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

Guest

What's wrong with this function:

=IF(20833<=K2<41667,((K2-20833)*0.05)+625,0) ?
 
=IF(AND(20833<=K2,K2<41667),((K2-20833)*0.05)+625,0)
HTH
Cordially
Pascal
 
Hi Feras

try
=IF(K2>20833,IF(K2<41667,((K2-20833)*.05)+625,0),0)

Regards
julieD
 
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

URGENT HELP - SUM FORMULA 5
If ,AND, LOOKUP, Functions 1
Check IF statement please 5
Nested IF AND OR statement 3
If then else 2
Help with nested function 10
Using Iserror with If statement and Vlookup 3
Nested IF not working..... 5

Back
Top