We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
How can I create this IF statement on Excel?
What I need to do is make an IF statement which will allow a cell (x) to have a value whereby if one cell (y) has been filled and has a value, that value will be in cell x. Or if another cell (z) has been filled in and has a value, that value you will be in cell x. Is this possible? And if it is how do I do it? Any help would be appreciated.
I’m not quite sure I’m understand what you want to do correctly but it seems that you could do this with a combination of the IF function and the ISblank function. Use the IF function to test if the cell is blank or not, putting the ISblabk function into the IF functions first argument. Then in the of functions second argument put what you want to happen if the cell is blank, which I think you leave blank if I understood you correctly. And then in the if functions third argument make it return the cell’s value.
Something along the lines of
If(is blank(z), , z)
I’ll try it out, if that fails its probably best to ask my teacher. Thanks anyway
-
What is the purpose of microsoft excel ? - 3 Answers
Hi, What is the purpose of microsoft excel ?? , I need a short but detailed description x
-
Create A Free Website - 1 Answers
what is a good webite where you can create your own website for free?
-
When you create a nano playlist, do you have 2 copies of a song? - 1 Answers
I only have 2000 songs on my nano. By creating playlists, does that use up some of my songs by creating duplicate songs?
-
Creating links on youtube? - 1 Answers
how do I create a link to my website on my youtube channel and on top of the discription on my videos?
-
thinking about creating like a youtube account Cool name? - 3 Answers
lol, I'm thinking about creating like a youtube account, and I wanna cool & creative name. lmao like something different. lik...
-
What kind of website should I create? - 5 Answers
I have a lot of experience with web development but have nothing to make have any ideas?
-
What program does Supermac18 use to create his awesome videos? - 3 Answers
What program does Supermac18 use to create his awesome videos? I want to use the program he uses because, he makes really coo...
-
How to create a clickable thumbnail of an image? - 1 Answers
I want to have a little thumbnail of a picture so that when you click it, it'll take you to a blank page with the picture's a...
-
How do you create a locker on your computer? - 1 Answers
well how do you do it I know it includes note book but thats all please help
-
how do I create an itunes account? - 3 Answers
how do I create an itunes account? is it free?
Excellent Digitizing
Embroidery Services, Vector Art Services, Digitizing Services
Excellent Digitizing LLC
Embroidery Services, Graphic Design Services, Logo Design Services
Excellence Technology
Information Technology, Career Development, Training Institutes
Excellent Webworld
Mobile App Development, Product Engineering, IT Services
Excellence Technology
Information Technology, Education, Professional Training