Is it possible to create an if/then formula with dynamic cells?

[djbcktt]

I would like F3 to equal E3-D3, if there is a number OR formula in E3. If there isn't anything in E3, then it would look to see if there is anything in D3. If there is, then D3-C3. If not, then see if there is anything in C3. If there is, then C3-B3. If not, then = B2. Is that possible? Thank you!!!! https://www.dropbox.com/s/yv0b91yg6545bbj/Excel Help 20150618.xlsx?dl=0

 

[igold]

How about this in Cell F3, copied down if need be...

=IF(E3<>"",E3-D3,IF(D3<>"",D3-C3,IF(C3<>"",C3-B3,B2)))


igold

 

[djbcktt]

Yes! Thank you! I couldn't figure out how to do it with blanks.

 

[igold]

Great, glad I could help. Thanks for the feedback.

igold