danager2020
New Member
- Joined
- May 13, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- Web
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".
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".