Hi, i don't have much experience with formula's but want my field to be blank if 0. how would i add this to the following formula?
=IF($B3<>"",SUMIF('SKU-2020'!$A$2:$A$1000,'CUTTING SHEET'!$B3,'SKU-2020'!$P$2:P1000)*$G3,"")
Would appreciate any help!
Last edited by Shell-in-Melb; 01-24-2020 at 09:11 AM.
Welcome to the forum.
Like this, perhaps:
=IF($B3=0,0,IF($B3<>"",SUMIF('SKU-2020'!$A$2:$A$1000,'CUTTING SHEET'!$B3,'SKU-2020'!$P$2:P1000)*$G3,""))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
how about =IF($B3=0,"",IF($B3<>"",SUMIF('SKU-2020'!$A$2:$A$1000,'CUTTING SHEET'!$B3,'SKU-2020'!$P$2:P1000)*$G3,""))
because I'm not sure of which part you are referring to, this might be what you want...
OR, =IF(AND($B3<>"",SUMIF('SKU-2020'!$A$2:$A$1000,'CUTTING SHEET'!$B3,'SKU-2020'!$P$2:P1000)*$G3=0),"",IF($B3<>"",SUMIF('SKU-2020'!$A$2:$A$1000,'CUTTING SHEET'!$B3,'SKU-2020'!$P$2:P1000)*$G3,""))
untested of course w/o workbook.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Wrap an IF around the existing formula. Unfortunately you need to repeat it. I have moved the check for B3 outside your original formula so as not to have to repeat that part.
=IF($B3="","",IF(SUMIF('SKU-2020'!$A$2:$A$1000,'CUTTING SHEET'!$B3,'SKU-2020'!$P$2:P1000)*$G3=0,"",SUMIF('SKU-2020'!$A$2:$A$1000,'CUTTING SHEET'!$B3,'SKU-2020'!$P$2:P1000)*$G3))
Great, thank you this works! Appreciate your help and all responses
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks