Need If condition formula for multiple Column

[Kulo5856]

Hi all, I need formula for a condition which the column A,B,C,D and i need total charges for the shipment weight
i used formula =IF(N3>=251,N3*2,IF(N3>=101,N3*1)) for single cell but i need for all cells

If weight morethan 101 multiply by 1 and weight more than 251 multiply by 2, then final result need to add total charges

Shipment weight	Total charges
A	B	C	D
35	115	256	320
93	168	451	680
296	325	105	222

 

[Gerald Higgins]

Hi, I've read your post a couple of times, it's just not clear what you want to do, exactly.

Your table refers to columns A, B, C, D, but the formula you posted refers to column N.
Is column N actually the same as column A, B, C, or D ?

In your formula, the part which multiplies by 1 may be redundant.

 

[Kulo5856]

Hi, I've read your post a couple of times, it's just not clear what you want to do, exactly.

Your table refers to columns A, B, C, D, but the formula you posted refers to column N.
Is column N actually the same as column A, B, C, or D ?

In your formula, the part which multiplies by 1 may be redundant.

Dear Gerald,
Thanks for your reply
Actually i need formula to get the IF condition, if Column A or B is morethan 101 multiply by 1 and weight more than 251 multiply by 2

 

[Gerald Higgins]

Hi, your request is still really unclear to me.

1) Bear in mind that multiplying by 1 doesn't change your input number at all, so why bother doing it ?
2) What if your input number is less than 101 ? What do you want to do then ?

Here's a simple formula that will look at the value in N3, and if the value in N3 is more than 251, it will multiply it by 2.

=N3*(1+(N3>251))

But I'm guessing you want something a bit more advanced than this, and I can't work out from your posts, what that is exactly.

 

[Kulo5856]

Sir i need formula for both A,B,C,D in one formula like =IF(A2:D2>=251,A2:D2*2,IF(A2:D2>=101,A2:D2*1)) while using this error came. so please share easiest formula

 

[Gerald Higgins]

So for this part . . .

=IF(A2:D2>=251...

what exactly do you want to do ?

Do you want to test if any single value in the range A2:D2 is greater than 251 ?
What happens if two or more values in that range are greater than 251 ?
OR, do you want to test if the sum of all values in the range A2:D2 is greater than 251 ?

 

[Kulo5856]

So for this part . . .

what exactly do you want to do ?

Do you want to test if any single value in the range A2:D2 is greater than 251 ?
What happens if two or more values in that range are greater than 251 ?
OR, do you want to test if the sum of all values in the range A2:D2 is greater than 251 ?

Sir

Shipment weight				Total charges
A	B	C	D	value morethan 101 upto 250 multiply by 1, Value morethan 251 multiply by 2
35	115	256	320	B>101, C>251, D>251
93	168	451	680	B>101, C>251, D>251
296	325	105	222	A>251, B>251, C>101, D>101

I need total charges which be

B>101, C>251, D>251 (115*1)(256*2)(320*2)

=115+512+640 =1267 ans

I need this from formula only sir

 

[Gerald Higgins]

Now we're getting somewhere !

So, if any of the values in A/B/C/D are less than or equal to 101, ignore them.
If any of the values in A/B/C/D are over 101, include them in the total.
If any of the values in A/B/C/D are over 251, double them.
Is that it ?

If YES, then this formula will give you the result as 1,267, for the example input values you gave.

=SUMIF(A1:D1,">101",A1:D1)+SUMIF(A1:D1,">251",A1:D1)

 

[Kulo5856]

Thank you for your immediate support sir..