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.

 

[JamesW]

Hi there,

Welcome to the board.

Try:

Col M = If(D2<100,D2/2,D2)
Col N = If(D2<100,D2/2,D2)

Not sure what you want to do if it's over 100, so I put the value in col D in there.

 

[NAVAJO EPA]

Post the answers in Column M and N and dont put it in Column D ?
Where to place the formulas.

Thank you very much

 

[NAVAJO EPA]

didnt work. o darn

 

[JamesW]

From what I understand in Column D you have the $ amount ($100 for example) and you want to put half of it in column M and the other half in column N (if under $100)?

In this case, as mentioned in my first post:

In Column M put = If(D2<100,D2/2,D2)
In Column N put = If(D2<100,D2/2,D2)

 

[NAVAJO EPA]

If Column D is less then $100. Divide Column D by 2.
Then put 1/2 in Column M and the other 1/2 in N.


The If greater then $100 formula wanted would be
Separate the total by putting 20% in Column G
The other being 80% in Column H


Please send me the formula. Thank you.

 

[NAVAJO EPA]

It is working - however it is calculating the greater then 100 as well and i dont want that to happen

how do i delete that part out when if it is greater $100 it should be
breaking it into 20% in column G and 80% in column H

 

[mancemonster]

Hi,


In M2 put =IF(D2<100,D2/2,D2*0.2)
In N2 put =IF(D2<100,D2/2,D2*0.8)

This will put 50% in M2&N2 if less than $100, and split 20% to M2, 80% N2 if equal or more than $100.

Regards

Roger

 

[NAVAJO EPA]

Working with the 50% but not with the 20% or 80% breakdown. Ugh.
Results left after pasting it in is #NAME?

Total check amount is in Column D

20% of the total of Column D is in Column G when greater then $100.00
80% of the total of Column D is in Column H when greater then $100.00
50% of the total of Column D is in Column M when less then $100.00
50% of the total of Column D is in Column N when less then $100.00

Payment type is in Column E (tarifff fees/ annual tank fees / and etc)

this is the formula in column g
=IF(E4="Tariff fees",D4*0.2,0)

this is the formula in column h
=IF(E4="Tariff fees",D4*0.8,0)

 

[mancemonster]

Ok...

Assuming that if D is more than $100 you want M&N to be blank..
Assuming that if D is less than $100 you want G&H to be blank..

In Column M put = If(D2<100,D2/2,"")
In Column N put = If(D2<100,D2/2,"")
In Column G put = If(D2>100,D2*.2,"")
In Column H put = If(D2>100,D2*.8,"")

Try telling us what you want to see...

If D=98 what is M,N,G,H
If D=100 what is M,N,G,H
If D= 180 what is M,N,G,H

Regards

Roger<!-- / message --><!-- sig -->
<!-- / message --><!-- sig -->