if then statement needed

Copper Contributor

Hi, I'm trying to figure out an if then statement, here is what I have so far, =if column C has a value of 1 then I want column F to be subtracted from column H and then the outcome of that to be multiplied by column I. How do I write this ?

1 Reply

@Todd105G That would be like this:

Riny_van_Eekelen_0-1658291337262.png

The ,0 at the end is the value that is returned when C1 does NOT equal 1. You didn't specify what needed to happen in such case. You can replace it by another formula, "" for blank or anything else you want to see here.