Hey all.

I know zero about excel, I'm hoping someone can help me.

I'm trying to write a manufacturing spreadsheet that will tell me how long it will take to hand print a piece of silk based on specific criteria.

So, I need a function box that someone can type YES/NO into and it will change the overall value.

For example:

A1 = 10
B1 = 10
C1 = 10
D1 total = 30

If E1 = yes, = A1, B1 + C1*2 (40)
but
If E1 = no, = A1, B1 + C1 (30)

I know some basic SUMIF /SUMIFS formulas but I can't figure this one out on my own!

Thanks in advance,
Hattie