Forum Discussion

AlbertClarke's avatar
AlbertClarke
Copper Contributor
May 26, 2023
Solved

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...

https://drive.google.com/drive/folders/0B_0fhpF9cZCiRllFQkppZFVfLVk?resourcekey=0-LbBLbS25Mmnk01eMuiYAgw&usp=share_link

=IF(A3<>"",IF(C3<>C2,C3-C2,IF(C3=C2,0,"")))

    • AlbertClarke's avatar
      AlbertClarke
      Copper Contributor
      Thank 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

Resources