Conditional formula

[OM2]

I'm a newbie to Excel

I need to do the following:

if A1 < 30, then a2 = 10% of a1
else a2 = 10% of 30 + 5% of (a1-30)

I'm not sure how I can have the above conditional logic on the cell A2

I know how to do basic assignment like =a1*b1 or something, but not conditional as given above

Any help would be appreciated

Thanks


OM

[teylyn]

if A1 < 30, then a2 = 10% of a1
else a2 = 10% of 30 + 5% of (a1-30)

formula to go into A2

=IF(A1<30,A1*0.1,(30*0.1)+((A1-30)*0.05)))

[OM2]

i knew it would be simple
thanks a lot

[zbor]

Or same formula shorter:

=IF(A1<30,A1*0.1,0.05*(A1+30))

[DonkeyOte]

OM2,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


Please ensure you title your threads more appropriate going forward... specifically I'm referring to "Help needed" etc...

[OM2]

understood - i'll do so in future
(do u want me to change the title now that the post has been answered? if so, let me know)

[zbor]

Yes, please. And make it solved (drop down menu left to the title )

[OM2]

i'm happy to try and comply
i went to edit my title - then i thought... my title sounds correct!
i don't think could give a better title!
not wanting to waste time or anything: please do give a suggestion what it should be?
i think the title is exact and correct

also: i couldn't find the 'mark solved' - honestly, i must have spent 5 min looking!

and: i just got a personal notification about my post and it says that i've got an infractions point - or something like that

wow: i have to admit, i like this forum - it's not good when a forum gets filled with junk
all forums should do the same and the world might be a better place

[zbor]

Where you renamed your title is drop down menu. Just choose [solved]

[DonkeyOte]

i'm happy to try and comply
i went to edit my title - then i thought... my title sounds correct!

If you read my post I think you'll note my suggestion.

and: i just got a personal notification about my post and it says that i've got an infractions point - or something like that

You should note I reversed the infraction almost straight away as I felt it was a little too zealous even for me.