Excel issue

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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","")
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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