Forum Discussion
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,"")))
2 Replies
- 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
