In cell D4 I have =Q8.
I only want it to =Q8 if cell H1 conatins a value and is not blank. If its blank I dont want anything in D4
What can I add here. Thanks
In cell D4 I have =Q8.
I only want it to =Q8 if cell H1 conatins a value and is not blank. If its blank I dont want anything in D4
What can I add here. Thanks
In D4 type =if(H1<>"",Q8,"")
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks