Is there a formula that will allow me to look for the existence of any number value in a row of one worksheet and then return a specific number value in a cell on another worksheet? For example, if the formula finds any number value it will always return the number 15 to a cell on another worksheet. Thanks in advance for any assistance.
Last edited by kahuna130; 03-15-2014 at 05:57 PM.
Formula as such only returns something in a cell or range it is written in.
You can achieve such effect by using macro.
Best Regards,
Kaper
As Kaper said, you'd need to put the formula where you want the 15 to be. If for example, you want a 15 if there is a number in sheet1!A4:G4 the formula might be
=IF(COUNT(sheet1!$A$4:$G$4)>0, 15, "")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Bingo! Thanks ChemistB!!! Worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks