Trouble with a formula

[danager2020]

Hello,

I'm trying to get my sheet to multiply D2 and E2 but ONLY IF there is a "B" in F2. I want to duplicate to rows 3 through (however many). The images below show my sheet and formula. Using Google Sheets which, to my understanding, uses the same/similar formula "stuff" as excel. I'm trying to create/duplicate this formula so I don't have to remember to put in to each line where the F# cell value is "B".

 

[Fluff]

Hi & welcome to MrExcel.
How about

=if(f2="B",d2*e2,"")

 

[danager2020]

That worked (after I fixed my own loop error)! Thanks!

I realized after copy/pasting your response that I was trying to multiply the cell containing the formula. I clearly wasn't off to a great start

 

[Fluff]

You're welcome & thanks for the feedback.