Hi!
Could anyone let me know how to refer to the D-column and if it's a blank cell there the cell with the formula will also be blank, instead of showing "0"?
Delete the 0.xlsx
Hi!
Could anyone let me know how to refer to the D-column and if it's a blank cell there the cell with the formula will also be blank, instead of showing "0"?
Delete the 0.xlsx
Try this........
in F16
=IF(D16="","",D16)
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Try
Formula:
=IF(D6="";"";D6)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Perfect! Thanks, guys! I really appreciate it! :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks