Excel functions

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hi,

Good day!

Can someone tell me formula to find the datas which range's between 1 - 5, 5 -10, 10-15 and so on till 95-100 in a column and mutlipy it with 2.5 and return it in cell.

example

2 "=range(1-5) *2.5" (if it is 1-5 multiply with 2.5 , if it is 5- 10 multiply with 5)
6
2
3
4
5
6

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
suppose data 2,6,2 etc are in A2,A3 A4 etc(A1 is having heading)
in B2 type this formula

=IF(AND(A2>=1,A2<=5),A2*2.5,IF(AND(A2>5,A2<=10),A2*5))

copy B2 down

If the value in col A is >=1 and <=5 then data will be multiplied by 2.5
if the value 6 and above upto 10 data will be multiplied by 5