Nov 29 2017
04:03 PM
- last edited on
Jul 25 2018
10:30 AM
by
TechCommunityAP
Nov 29 2017
04:03 PM
- last edited on
Jul 25 2018
10:30 AM
by
TechCommunityAP
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.
Nov 29 2017 05:00 PM
Solution=IF(C5=0,AK5,D5-C5)