SOLVED

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

https://drive.google.com/drive/folders/0B_0fhpF9cZCiRllFQkppZFVfLVk?resourcekey=0-LbBLbS25Mmnk01eMui...

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

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@AlbertClarke 

Perhaps

 

=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