IF a1, b2, c5 = 0 then d1 value = "Error Cells not filled"
What is precise function for actions like these?
IF a1, b2, c5 = 0 then d1 value = "Error Cells not filled"
What is precise function for actions like these?
Do you mean if one or all of them equal 0?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
And do you mean 0 or Blank ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
=if(OR(A1=0,B2=0,C5=0),"Error Cells Not Filled",-insert whatever formula you need in D1 here-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks