Formula for cell that is not blank
I have a three sheet Excel document on sheet 3 if AM2 is not blank I need a value of x on Sheet 1 D1. Any assistance would be greatly appreciated.
Computers & Internet - Microsoft - Excel - Excel for PC
Copyright © 2024 QA.XPDF.PUB - All rights reserved.
Answers & Comments
You can use IF and ISBLANK. Put this formula on Sheet 1 D1:
=IF(ISBLANK(Sheet3!AM2),"x","")
You can replace "x" by any other value you need.