Multiple IF function (maybe OR)

M

mpenkala

Hi all,

I need some help with a chart I'm making.

I want an if function to do the following:

IF B1=1,2,3 or 9, then mark B2 with an "x".

Should be simple, but I can never figure out the multiple numbers.

Thanks,
Matt
 
M

mpenkala

Hey Bernard,

how can I modify this formula so that it doesn't give me an "x" when the
cell is blank and my formula is
=IF(OR(B1={0,1,2,7}),"X","")

Thanks!
Matt
 
D

David Biddulph

=IF(B1="","",IF(OR(B1={0,1,2,7}),"X",""))
or
=IF(AND(B1<>"",OR(B1={0,1,2,7})),"X","")
 

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

How to Select Multiple Emails using Surface Pen 0
Calculate the median value before a specified list 0
Finding the weighted average of text that have been given values 1
Setting a default zoom in Infopath 0
Multiple formats in one cell 1
Move between slides using Macros 0
Use TODAY() function as the criteria in a SUMIF formula 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top