If Formula for excel

[NAVAJO EPA]

Excel Formula
I need a formula for my report records.

If in column D the amount is less then $100. divide the number by 2.
Put 1/2 of the number in column m and the other 1/2 of the number in column n.

 

[NAVAJO EPA]

tHANKS

I do want the zero to be in the columns that dont get used.

If greater then 100 then break 20% / 80% but columns m & n = $0.00

If less then 100 then break 50% / 50% but columns g & h = $0.00

hope that is english excel terms of understanding....

i laugh.

 

[NAVAJO EPA]

but only break down if in column e states that it is a tariff check.
then break down according to
greater then $100.00 = 20%;80% with $0.00 in columns (m&n)not used.
less then $100.00 =50%; 50% with $0.00 in columns (g&h)not used.

 

[mancemonster]

Aha!

Not quite the original question!


In Column M put = If(D2<100,D2/2,0)
In Column N put = If(D2<100,D2/2,0)
In Column G put =IF(AND(E2="Tariff Check",D2>=100),D2*0.2,0)
In Column H put =IF(AND(E2="Tariff Check",D2>=100),D2*0.8,0)

This will now put half of D2 in M&N if D2 less than 100, if more than/= 100 it will put 0.

In G2 it will check if E2 has Tarriff Check and if D2 more/= 100 will return 20% if not 0.

In H2 it will check if E2 has Tarriff Check and if D2 more/= 100 will return 80% if not 0.

Does that do the job?


Regards

Roger

 

[NAVAJO EPA]

but only break down if in column e states that it is a tariff check.
*** use for all columns m&n- g&h ***

then break down according to
greater then $100.00 = 20%;80% with $0.00 in columns (m&n)not used.
less then $100.00 =50%; 50% with $0.00 in columns (g&h)not used.

 

[NAVAJO EPA]

The formulas given works. I dont have to make it perfect. thank you so much for all your help. The record/ report looks better then ever now.

 

[mancemonster]

In Column G put =IF(AND(E2="Tariff Check",D2>=100),D2*0.2,0)
In Column H put =IF(AND(E2="Tariff Check",D2>=100),D2*0.8,0)

In Column M put =IF(AND(E2="Tariff Check",D2<100),D2/2,0)
In Column N put =IF(AND(E2="Tariff Check",D2<100),D2/2,0)

 

[NAVAJO EPA]

Once more I need help. I lost my files with all the codes- I need help once ore to figure out information - THANKYOU!

 

[NAVAJO EPA]

I got it figured out! Took me a few minutes to get it back !!!! YAY