Need Help for Excel "If Function"

• pierre^^

  3 Sep 08, 09:54

  Hi Guys

   

  I want to create a IF function in excel that will do this

   

  1 m2 = SGD 9

  Minimum = SGD 60

   

  So if i key in any number below 7 m2, it will show SGD 60, but above 7m2, it will auto calculate based on m2 x Amount which is SGD 9

   

  How to do?

   

   

• Mospeada

  3 Sep 08, 09:56

  IF(m2<7, "SGD 60", m2*amt)

• pierre^^

  3 Sep 08, 10:24

  Thank you so much Mospeada 

   

   

• pierre^^

  3 Sep 08, 10:28

  Hi

   

  One more question

   

  if SGD 22 Per 4 M2

  So if i key in between 1-4,. it will show SGD 22

  But if i key in 5-8, it will show SGD 44

  If i keep 9-12, it will show SDG 66

   

  issit possible to do this function?

   

   

• Mospeada

  3 Sep 08, 10:38

  Originally posted by pierre^^:

  Hi

   

  One more question

   

  if SGD 22 Per 4 M2

  So if i key in between 1-4,. it will show SGD 22

  But if i key in 5-8, it will show SGD 44

  If i keep 9-12, it will show SDG 66

   

  issit possible to do this function?

   

   

  then u got to do multiple liao...IF inside the IF

   

• Mospeada

  3 Sep 08, 10:45

  i think i can only help u better if you put those data in rows and column, since you want to know how to structure the equation

• eagle

  3 Sep 08, 10:48

  Originally posted by pierre^^:

  Hi

   

  One more question

   

  if SGD 22 Per 4 M2

  So if i key in between 1-4,. it will show SGD 22

  But if i key in 5-8, it will show SGD 44

  If i keep 9-12, it will show SDG 66

   

  issit possible to do this function?

   

   

  Not sure if this can work

  =(INT(m2/4)+1)*22

• pierre^^

  3 Sep 08, 10:55

   

  Mospeada like this?

• pierre^^

  3 Sep 08, 11:03

  

• pierre^^

  3 Sep 08, 11:53

  Originally posted by eagle:

  Not sure if this can work

  =(INT(m2/4)+1)*22

  
  Thanks so Much Eagle

   

  It works :D