Thread: if function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Peter Peter is offline
external usenet poster
 
Posts: 349
Default if function

Hi doing my cert 2 and i am stuck on 1 formula
i need to work out the total cost of something where the first 1000 are
$0.50 and anything over 1000 is $0.40 using if function.
It all seemed so straught forward till i got to this.
Thanx in advance