Help with formula to auto add a fixed number

[Dougie12.]

Below is a simple table. I've highlighted the yellow cell C2. Basically I'm struggling to find a formula that automatically adds the number 75 to the total cell F2 if any number above 0.00 is input into cell C2.

Relatively simple for you guys but not me I'm afraid. The cell F2 must also add A2, B2 and D2 in addition to C2 and 75.

If nothing is input in cell C2 then only A2, B2 and D2 will be the answer.

(Apologies if the title of my thread is inaccurate but you don't know what you don't know, so to speak)

[dilipandey]

Hi Dougie.

Cell c2, d2 and f2 are blank and out of your data boarders... I believe you need to mention correct cells. Thanks.

regards,
DILIPandey

<click on below 'star' if this helps>

[Dougie12.]

My apologies, got it totally wrong DILIPandey. Here we go again...

Below is a simple table. I've highlighted the yellow cell B4. Basically I'm struggling to find a formula that automatically adds the number 75 to the total cell in B7 if any number above 0.00 is input into cell B4.

Relatively simple for you guys but not me I'm afraid. The cell B7 must also add B2, B3 and B5 in addition to B4 (and of course 75).

If nothing is input in cell B4 then only B2, B3 and B5 should be the answer.

(Apologies if the title of my thread is inaccurate but you don't know what you don't know, so to speak)

[Fotis1991]

Hi.

Try this in B7

=IF(B4="";SUM(B2:B5);IF(B4<>"";SUM(B2:B5)+75))

Does it helps you?