How do I set up a function that...

J

John

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?
 
J

JE McGimpsey

One way:

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

Copy down as far as necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Excel does not accept text format! 0
Crating User Form to Add Names 1
AppleScript - How do I select a text ? 1
Merging from an Excel file with graphics 1
Cell data entering slow! 0
Conditional Formatting to Another Cell 0
Need Help with a VBA subroutine 0

Top