Nested IF formula

Copper Contributor

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


2 Replies
best response confirmed by VI_Migration (Silver Contributor)




=IF(A3="", "", C3-C2)

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