10 posts
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?
IF(m2<7, "SGD 60", m2*amt)
Thank you so much Mospeada
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?
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
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
Not sure if this can work
=(INT(m2/4)+1)*22
Mospeada like this?
Originally posted by eagle: Not sure if this can work =(INT(m2/4)+1)*22
Thanks so Much Eagle
It works :D
Signup
Login
10 posts
10 posts
