VISHAL120
10-26-2011, 12:38 AM
Hi All,
I needed help with the below formula which is not working :
H4-IF(C4<>"",B4,IF(AND(C4<>"",D4<>""),B4*2,IF(AND(C4<>"",D4<>"",E4<>""),B4*3,IF(AND(C4<>"",D4<>"",E4<>"",F4<>""),B4*4,IF(AND(C4<>"",D4<>"",E4<>"",F4<>"",G4<>""),B4*5)))))
In fact i have one column which keeps the daily target example 200 pcs. what i want is to see the varaince from the daily production total versus the targeted qty on a daily basis.
that is every time the daily production is enter the target qty shall change accrodingly.
example :
target : 200 pcs
1st day prod 120,
the target will be : 200
2nd day prod : 120
the target shall be : 400
and then on the varaince column i do total prod - total targeted like :
240-400 to see the varaince .
but with my formula its remaining still with the first day.
thanks to see attached sheet for examples.
Many thanks for the help if this is possible.
:help
I needed help with the below formula which is not working :
H4-IF(C4<>"",B4,IF(AND(C4<>"",D4<>""),B4*2,IF(AND(C4<>"",D4<>"",E4<>""),B4*3,IF(AND(C4<>"",D4<>"",E4<>"",F4<>""),B4*4,IF(AND(C4<>"",D4<>"",E4<>"",F4<>"",G4<>""),B4*5)))))
In fact i have one column which keeps the daily target example 200 pcs. what i want is to see the varaince from the daily production total versus the targeted qty on a daily basis.
that is every time the daily production is enter the target qty shall change accrodingly.
example :
target : 200 pcs
1st day prod 120,
the target will be : 200
2nd day prod : 120
the target shall be : 400
and then on the varaince column i do total prod - total targeted like :
240-400 to see the varaince .
but with my formula its remaining still with the first day.
thanks to see attached sheet for examples.
Many thanks for the help if this is possible.
:help