Quote Originally Posted by Rivindu View Post
Okay sorry i was being quite rude because i was in a hurry.
Sir Richard,
This is what I tried , but it didnt work , can you tell me whats wrong please ?

=IF(F3<=4,F3*2,IF(AND(F3>4,F3<=7,F3*5))
Don't worry, I didn't take this as being rude. We generally make allowances for non native English speakers and different cultural way of speaking.
Jonmo has already given you an answer but one additional tip: always count the number of both the opening and closing parentheses. These should always be the same. If you find a formula you write isn't being accepted into the cell then check this first.