Yes or No result

[go77377]

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.

 

[Fluff]

If C5 can only be Y or N try
=IF(C5="N",B5,B5*1.0825)

 

[go77377]

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

 

[Fluff]

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

 

[go77377]

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

 

[Fluff]

You're welcome & thanks for the feedback