Excel issue

Closed
sanober - Aug 15, 2010 at 05:47 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Aug 17, 2010 at 11:45 PM
Hello,

I have a problem that if i have excel sheet of 20 rows and 200 columns and i want to perform some function like comparing each entry with certain number (for eg :0.25) and if the entry is greater than 0.25 then function returns "yes" else it returns "". how can i do it using excel ?

3 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Aug 16, 2010 at 05:56 AM
you need another set of empty cells 20x200. In this range of empty cells if you type the formula in the first left hand cell then you can just copy that down and to the fight I have given a small example sheet which you can download from this web page

http://www.speedyshare.com/files/23821960/sanober.xls

suppose data is in A1 to A10 and B1 to b10 that is 10x2

now see the formula in D1.
copy D1 down upto D10 and also E1 to E10.(using control+c and control+v)
1
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Aug 15, 2010 at 10:04 PM
quote
comparing each entry with certain number (for eg :0.25) and if the entry is greater than 0.25 then function returns "yes" else it returns "
unquote

in an empty cell type this formula(suppose parent cell is A1)

=if(a1>0.25,"yes","")
0
thanks venkat, it worked ! can i perform the same thing for the entire table of 20x200 dimension. i mean can i specify the range of entire table for performing comparison of values against 0.25 , because doing one by one for each entry will take much time

-thanks in advance
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 17, 2010 at 11:45 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0