I Want one formula in cell "c3" to know if all numbers in column "a" is multiplications or divisions of "5"
A
5 10 15 20 25 30 35 40 2.5 1.66666667 1.25 1 0.83333333 0.71428571 0.625 0.55555556 0.5 0.45454545 0.41666667 0.38461538
how can i write formula like this
if a2 = "multiplications and divisons of number 100", then .......
a2=200
multiplication of 100 =200,300,400,500,....
divisions of 100 = 50,25,12.5,........
*****************************************************
how can i say if all cells from a2:a8 = same number then ....
I need formula for dynamic ytd calculation for the scenario mentioned below.
YTD YTD YTD
Month Apr-13 Apr-13 Apr-13 May-13 May-13 May-13 June-13 June-13 June-13 May-13 May-13 May-13
Product type x y z x y z x y z x y z
sales executive
a 5 10 15 20 25 30 35 40 45 ? ? ?
b 4 8 12 5 7 11 12 69 79 ? ? ?
Is there an excel format...custom maybe that if I enter 19,500 it will display just 19.5 or just 19?
View 3 Replies View RelatedI am comfortable with getting a macro to copy & paste where I need it to, however how to get the macro to recognise when a certain value has stopped.
For example in Column B on "DataDrop" are all the divisions that exist in my company i.e East Anglia, Essex, London etc. There is an empty row between each division.