Hi i need to write a macro and have no idea how to do it if some one can show
me form scratch

Ihave different formalus in different column which calculate commission for
agent
Eg : if(d1247300,"$15",if(d1247100,"$12","$10"))-(j1247+k1247)

=IF(D12461500,"$25",IF(D12461000,"$20",IF(D1246 500,"$15","10")))-(J1246+K1246)

this 2 different formula in same column

i want to write a macro so i dont have to use two different formula when i
say certain column is X then its should run 1st formula if i select "y" it
should run 2nd formula.

Any help is appreciated.


--
Nisha P