How to paste the result (already compare values) to columns

Hi, everyone
I've got some trouble in vb and dont know how to do with it
I want to paste the result in to another column with the conditions like that

+ If 0 < money column < 500 & 0< Card column < 5 then paste the result (condition 1 is the result I expect to have)

+ If 500 =< money column & Card column >=5 then paste the result(condition 2 is the result)

I really thanks 4 anyone help me with this thanks u all read my post

I'm so sorry for my mistake
I have already attach again the result i want to get
Thank u so much

Thank u to help me with this
But I want to use VB macro to do this(cause using IF then when i create a new blank sheet I will not work(based on the current sheet))
Thanks

Thank u so much patel , one more thing I want to ask
If I have one more column such as Place(USA,UK...) how do i paste the results with one more column (the same way like u do with Number 1,2,3...) I have try but not work
Thanks patel