If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
if or function; please help
I am new to excel so please bear with me.
I have colomn a1:a8 with numbers A 1 5 2 4 3 7 4 3 5 2 6 0 7 1 8 0 In B1 thru B8 I want to get the minimum of A1:A8 other than zero but if corresponding row on A is zero return zero, for ex: B1:B5 and B7 would return a value of 1 and B6 and B8 would return 0 somebody please help me with a macro. Kind Regards Dan --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
try =IF(B1=0,0,1)
"hdayanan " wrote: I am new to excel so please bear with me. I have colomn a1:a8 with numbers A 1 5 2 4 3 7 4 3 5 2 6 0 7 1 8 0 In B1 thru B8 I want to get the minimum of A1:A8 other than zero but if corresponding row on A is zero return zero, for ex: B1:B5 and B7 would return a value of 1 and B6 and B8 would return 0 somebody please help me with a macro. Kind Regards Dan --- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
really simple thing - if you dont need the 0's blank them
then use the formual min(range) |
#4
|
|||
|
|||
whoops - shoudl have said if you dont need the 0's delete
the 0's then use the formula in col b like =IF(a1="",0,MIN ($a$1:$a$8)) and copy it down it shoudl do the trick Gary OZ |
#5
|
|||
|
|||
Will this work?
In B1 enter: =IF(A2=0,0,MIN(IF($A$2:$A$90,$A$2:$A$9))) and enter with CTRL SHIFT ENTER (an array formula) -----Original Message----- I am new to excel so please bear with me. I have colomn a1:a8 with numbers A 1 5 2 4 3 7 4 3 5 2 6 0 7 1 8 0 In B1 thru B8 I want to get the minimum of A1:A8 other than zero but if corresponding row on A is zero return zero, for ex: B1:B5 and B7 would return a value of 1 and B6 and B8 would return 0 somebody please help me with a macro. Kind Regards Dan --- Message posted from http://www.ExcelForum.com/ . |
#6
|
|||
|
|||
patti and anonymous,
Both the formulas worked, I greatly appreciate your help and time. Kind Regards Dan --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Newbe help - VBA function | Kristen | Worksheet Functions | 2 | April 21st, 2004 10:30 PM |
Customising the Function Wizard | Frank Kabel | Worksheet Functions | 1 | April 20th, 2004 06:46 PM |
Excel Add-Ins Incomplete Gamma Function | Harlan Grove | Worksheet Functions | 9 | April 15th, 2004 09:30 PM |
Need a DAYSINMONTH function to create a sales pace spreadsheet | MOTOGEEK | Worksheet Functions | 4 | April 12th, 2004 05:52 PM |
Function for % gain? | Norman Harker | Worksheet Functions | 4 | April 1st, 2004 11:54 AM |