SOLVED

Formula using If Function

Copper Contributor

I am trying to write a formula and it is not working out.

If the value of cell C5 = 0, then i want the value of AK5 to be returned.  If it is not zero, then I want the result of d5-c5 to be displayed.  Please help.

1 Reply
best response confirmed by joann.linscott (Copper Contributor)
Solution

=IF(C5=0,AK5,D5-C5)

1 best response

Accepted Solutions
best response confirmed by joann.linscott (Copper Contributor)
Solution

=IF(C5=0,AK5,D5-C5)

View solution in original post