Questions & Answers for: Microsoft Excel d1

...e by 50 % etc. sumif accounting formulas Type in the cell you want the IF formula to be in =if(D1="RO",E1*70%,E1*50%) I hope this

...to count how many of an item that meets 2 other criteria Lets say your data (cars) is in range "D1:D21". You need to know how many are Dodge and Ford in cell E1. =COUNTIF(D1:D21,"Dodge") +

...the sum in b2 and so forth. 4 4 4 8 0 8 4 12 Then i need a countdown. I start with a value 100 in d1. Then the value decreases by the value in e1. Example d1 e1 100 0 95 5 can you help with these ...

...again. Hello, You can use a colon to find a function over a group of cells. For example "=AVERAGE(D1:D10)" would find the average of the values within cells D1 through D10. Hope that ...

...value replace with d cell value/c value if N cell value is Zero. Thanks, Jas TRY THIS =if (n1=0,d1/c1,n1) if n1 = 0 than d/c else ...

...020129940 the criteria range is this cloA cloB colC 0101 formula will be. =DPRODUCT(A1:C10,B1,D1:D2)*DPRODUCT(A1:C10,C1,D1:D2) bye

Cell A1 ''A'' Cell B1 ''w'' Cell C1 ''A'', Result Cell D1 ''A'' I am using MS Excel I want following solution .In Cell A1 ''A'' Cell B1 ''w'' Cell C1 ''A'', I want result in Cell D1 ''A'' tell me the ...

...I have a three sheet Excel document on sheet 3 if AM2 is not blank I need a value of x on Sheet 1 D1. Any assistance would be greatly appreciated. You can use IF and ISBLANK. Put this formula on ...

...should be something like this: A1: Number to increase / decrease B1: % change C1: 'INC' or 'DEC' D1: =IF(C1='INC', A1+(A1*B1),