ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I set up a function that... (https://www.excelbanter.com/new-users-excel/63055-how-do-i-set-up-function.html)

John

How do I set up a function that...
 
How do I set up a function that allows for me to say that if any cell in
column a equals a particular number than another cell in that row will equal
a name?

JE McGimpsey

How do I set up a function that...
 
One way:

B1: =IF(A1=<particular number,"a name", "")

Copy down as far as necessary.

In article ,
"John" wrote:

How do I set up a function that allows for me to say that if any cell in
column a equals a particular number than another cell in that row will equal
a name?



All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com