So you want two outputs for the same exact sell. We have this sort of situation we have a monitor or an HD monitor. We're selling an item and we have a payment plan, or we pay in full. So we wanna know what is the first payment here. Now, if the pay type, let's do drop down here is planned, we want to say, okay, only a third of this or a 12th of this. If it's like a yearly plan, and if it's full, meaning just pay the whole thing in full. We want to have in the first payment column. The entire price. So we're gonna hit done, and this is just a dropdown . This could be text, could, it doesn't really matter, it's just text. So we have a plan here and we say full here based on that we want in this D column to do something different.

So if it's a plan, so if use the IF formula and we select the C two here, or type in C two and. Is equal to plan. If it's only two things, you can do this 'cause it's only gonna be true or false. And if, if the value is true, we're gonna take this number , divide it by 12, and if it's false, we're just gonna have that number . And so you see here, based on this first logical expression , we can have two different outputs in the same cell. And we can copy paste this and say, okay, this full one that's just 50. $500. However, what if you have more than two things here? It's not just true or false. Well, we do have switch and that expression is just going to be C two.

And in the case that it is plan, do this divided by 12 and maybe we have yearly plan here. And we also have quarterly plan. And for each case, whatever that is, we're gonna put a new thing here. So we di divide it by four, and if it's full, we're is gonna have this number . So for each match , there's going to be a different output and it's gonna say No match here, because we don't have yearly plan, but we can just add them here. I can say yearly plan, add another item, quarterly plan, click done, apply to all. Let's change that to yearly plan. And you see now we have the payments. We can also format this as dollars. And here if we have a quarterly plan, it's just dividing it by four.

There you have multiple outputs, same sell. Based on some kind of text value . Okay. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.