# Yes or No result

#### go77377

##### New Member
Me being out of touch with Excel has me being lost at the moment.

Can someone guide me on what I'm missing here?

This is what I'm trying to obtain. If a "Y" is entered in cell "C5", it will use a multiplier for tax placed in the cell "D5". If a "N" is used it will use the default amount in the "B5" cell.

B5 Cell is the cost of a item
C5 Cell you enter "Y" or "N" if tax is applied.
D5 Cell is the result of the "Y" or "N".

This is what I have so far, but the "N" needs to display the "B5" amount if no tax is applied................This part works ok, just missing the rest of the formula =IF(C5="Y",B5*0.0825+B5)

Hopefully this isn't too confusing the way I explained it.

Last edited:

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
If C5 can only be Y or N try
=IF(C5="N",B5,B5*1.0825)

I couldn't get that to work, unless I attached it incorrectly to the existing formula...... Thank you

That's the entire formula, no need to add it to anything

Thank You, Thank you..... I overlooked it

You're welcome & thanks for the feedback

Replies
16
Views
303
Replies
3
Views
281
Replies
6
Views
1K
Replies
3
Views
246
Replies
10
Views
359

1,203,223
Messages
6,054,228
Members
444,711
Latest member
Stupid Idiot

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back