Forum Discussion
AlbertClarke
May 26, 2023Copper Contributor
Nested IF formula
This formula works good until the first referenced cell is an empty cell, then it returns FALSE. I couldn't find any buttons to upload the sheet, so I posted a copy here...
=IF(A3<>"",IF(C3<>C2,C3-C2,IF(C3=C2,0,"")))
- AlbertClarkeCopper ContributorThank you SO much, Hans! i forgot the first rule of programming KISS, Keep It Simple Stupid, that's me! Stupid!! lol your formula works as intended! thank you again