Microsoft Excell Formula If Then -


i have question relates if, formula on microsoft excel. here trying unable write correct formula:

if(g2<=30000,"-g2*.003"))     

if column g2 less $30,000 g2 x .003 subtracted. otherwise, g2 x .002 subtracted.

thank help.

=if(g2<30000, g2-g2*0.003, g2-g2*0.002) 

mind "less 30k" have "less or equal 30k" in proposed code...


Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -