confusing

Hi there I'm working on excel template where column E formula would be =IFS(F8<$Q$3,F8*$P$3*$O$3,AND(F8>$Q$3,F8<$Q$4),F8*$P$3*$O$4,F8>$Q$4,F8*$P$3*$O$5) this is working fine, but when column F is blank it shows #VALUE !, how can fix this to show blank. also is there a way we can update...

I cannot figure out how to write an IF statement. IF 9,000 or less = 0, IF 9001 - 11999 = 3, IF 12000 - 14,999 = 4, IF 15000 or greater = 5 Please help I've been trying different things for almost 2 hours and I'm confusing myself now!

Hi All, I have somewhat recently stepped into a role and the person who had the post before me did reporting in horribly archaic ways - that I am trying to duplicate as my company doesn't use pivot tables. I could use some help. I am trying to build out this template for 2018 to links to...

Hi Why in excel VBA there are 2 classes one is Workbook and the other is Workbooks. It is so confusing to have 2, what is the reason? Thanks

Can anyone explain this formula and what it is doing? The OFFSET is confusing me. =IF(OR(ISBLANK(M67),ISBLANK(C67)),"",IF(OR(ISBLANK(N67),Q67=0,Q67=-1),(L67-M67)*100/D67,((L67-M67)-(AVERAGE(OFFSET(O67,(Q67+1),0)/300*N67,OFFSET(O67,(Q67+(IF(OFFSET(A67,Q67,0)="SEED",0,1))),0)/300*N67)))*100/D67))

Hello friends, I have a question that is bothering me for some time now, and it is a bit difficult to explain, hope you will understand:confused:. I have a sheet that looks like the table below. <tbody> 1 7 13 2 8 14 3 9 15 4 10 16 5 11 17 6 12 18 </tbody> Now...