Hi
I have this formula
Formula:Please Login or Register to view this content.
I want it to return 0.1 if what it is looking at has no value, but it keeps returning 0.0....
What am i missing?
Dan
Hi
I have this formula
Formula:Please Login or Register to view this content.
I want it to return 0.1 if what it is looking at has no value, but it keeps returning 0.0....
What am i missing?
Dan
try this..
Formula:Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Maybe..
=MAX(SUMIFS(Sheet2!$AT:$AT,Sheet2!$AP:$AP,V7,Sheet2!$AS:$AS,V5,Sheet2!$AQ:$AQ,V10),0.1)
Life's a spreadsheet, Excel!
Say thanks, Click *
While others have already solved the problem...
I'll just answer the actual question..
Sumif(s) doesn't error when there are no matching values, it simply returns 0
0 is NOT an error, it's a prefectly valid and real numerical value.
Therefor the Iferror doesn't see it as an error, so it just displays the result of the sumifs... 0
Hi Both
They work great, but something i forgot to say/do was look at a cell text before doing this....
Basically in cell V10 it will say "Shop", "Bulk" or "Direct", if it says "Shop" i want it to do the sumifs, and either return a value its looking at or o.1, but if its "Bulk" or "Direct" i want it then to say 0.0....
Using the Max function it still returns 0.1, i cant figure out how to incorporate if(cell="Shop",Sumifs,if(cell="Bulk",0,if(cell="Direct",0)))..... which is what i would usually do
use
=IF(V10="Shop",MAX(SUMIFS(Sheet2!$AT:$AT,Sheet2!$AP:$AP,V7,Sheet2!$AS:$AS,V5,Sheet2!$AQ:$AQ,V10),0.1),0)
Brilliant thank you all
Glad to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks