Simple conditional formula

[Steel_Tiger]

Hi, I"m trying to create a simple formual on Excel that will calculate 2 different amounts based upon whether I enter Y or N in another cell.

If I enter N, then calculate at 65%

If I enter Y, then calculate at 70%

I know this is probably simple, but my brain is getting fried. I'm self taught on Excel, but advance things are beyond me.

[#2]

assuming the Y/N is in cell A1 and the cell to multiply is B1 then something like:
=IF(A1="Y", B1*0.7, B1*0.65)
or if you want to allow any value starting with "Y" like Yes, Yep, You Bet, ... then
=IF(LEFT(A1,1)="Y", B1*0.7, B1*0.65)

[#3]

A1 B1 C1
$1000 Y (=70% of A1)
or
$1000 N (=65% of A1)

So depending on whether B1 is Y or N, I would like it to calculate the appropriate %

Am i making sense?

[#4]

I GOT IT!!!!! Thank you so much.