Previous Topic Next Topic

Excel functions

Closed
prasoon - Mar 18, 2010 at 05:13 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 18, 2010 at 07:05 AM
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
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 18, 2010 at 07:05 AM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses