Need quick "if" function
How do I get a value to repeat itself if it's under or over a certain value.
for example. Is a value is greater than 5 in one cell, then I want to repeat it in another column of cells I want to do the same for when a value is less than say, 5.1 ... and have it repeat in a different column of cells. What's the easiest way to do that? Thanks so much. Diana |
Need quick "if" function
Not sure if I follow your question. Think you want to show a number as long as it's not 5 If that's correct say put this forumla in B2 and drag to what every cells you want to populate. enter number to repeat in cell A1 =IF($A$1<5,A1,"") If you want to repeat the value in the same cell then use where 6 is the number of times you want it to repeat =IF($A$1<5,REPT(A1,6),"") VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565783 |
Need quick "if" function
=if(A15,A1,"")
etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Cowtoon" wrote in message ... How do I get a value to repeat itself if it's under or over a certain value. for example. Is a value is greater than 5 in one cell, then I want to repeat it in another column of cells I want to do the same for when a value is less than say, 5.1 ... and have it repeat in a different column of cells. What's the easiest way to do that? Thanks so much. Diana |
All times are GMT +1. The time now is 09:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com