Forum Discussion

Copper Contributor

Apr 18, 2020

Adding number in the same table

I have the following table If fuel <> 0 then add a new column Total Miles = 0 IF fuel = 0 then the Total Mile = 0 + 10 = 10 If fuel = 0 then the Total Miles = 30 + 10= 40 If fuel <> 0 then...

Formulas and Functions

mtarler

Silver Contributor

Apr 21, 2020

Tia RojasIn col F the formula should be =if(D5=0, C5+F4,0)

and in col G the formula should be =if(D5=0, 0, C5+F4)

Tia Rojas

Copper Contributor

Apr 21, 2020

mtarlerWOW that is that I need.

Thank you for the help and lesson on excel. I think I can see your point now.