I have the following formula in cell J2: =(((E2+H2)*(0.029))+0.3) which brings a result of .30 even if cell E2 is empty. I would like J2 to remain blank or 0 if E2 is blank. Thank you. Grind.
I have the following formula in cell J2: =(((E2+H2)*(0.029))+0.3) which brings a result of .30 even if cell E2 is empty. I would like J2 to remain blank or 0 if E2 is blank. Thank you. Grind.
=(((E2+H2)*(0.029))+0.3)
change to
if you want a blank
then
IF( E2="", "", (((E2+H2)*(0.029))+0.3))
if you want 0
then
IF( E2="", 0, (((E2+H2)*(0.029))+0.3))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Welcome to the forum
To avoid coercion issues I'd be inclined to use
J2:
=SUM(E2,H2)*0.029+0.3*(COUNT(E2)=1)
As etaf has highlighted - if H2 is to be disregarded where E2 is devoid of number then the above would require modification.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks Wayne and Donkey- worked great. My puzzler can heal. I am unable to conditionally format one column to make the zeros white and thus invisible- worked in all the other
columns...Jim
with the conditional format - you may want to start a new thread with this issue and also post an example spreadsheet with no sensitive information
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks