View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jcparham@gmail.com is offline
external usenet poster
 
Posts: 1
Default Using the IF formula

I am trying to use the if statement to the following pruposes:

if A1 is greater than 13000 but less than 14000 then £25 is entered
into the cell. however:
if A1 is greater than 14000 but less than 15000 then £35 is entered
into the cell. however:
if A1 is greater than 15000 but less than 16000 then £50 is entered
into the cell. and so on

Has anyone anu ideas how to acheive this??

Thanks

John