Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Functions
I need to return a True or False Value in Columns G and H Using the data in columns A through F. Below is an example of the data I am working with: A B C D E F G H 6 1.50 1000 128.30 1000 75.7 Help Award 7 Joe 0.00 0.00 0.00 0.00 0 8 James 5.45 1190 91.54 330 58.93 9 Jay 0.00 530 96.36 5544 69.96 10 Jack 1.21 9833 103.23 408 65.28 11 Jan 0.60 0 0.00 7633 65.38 12 Jane 1.18 3879 111.63 4591 62.68 I need Column G to indicate an employee needs "Help" (Jack as example) B10B6*.90 OR, C10C6 AND D10<D6*.90 OR, E10E6 AND F10<F6*.90 If ANY of these are true, then the employee needs help I need Column H to indicate that an emplyee gets and "Award" if they are =or< 1 in Column B, have =or 1000 in Column C AND =or 128.3 in Column D OR have =or 1000 in Column E AND =or 75.7 in Column F So employees must have 1 or less in Column B (first step) AND 1000 or over at a rate of 128.3 or Greater OR 1000 at a rate of 75.7 or Greater (second step). Thanks in advance for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Functions
Try these two formulas and copy them down.
G7=OR($B7$B$6*0.9,AND($C7$C$6,$D7<$D$6*0.9),AND( $E7$E$6,$F7<$F$6*0/9)) H7=AND($B7<=1,OR(AND($C7=$C$6,$D7=$D$6),AND($E7 =$E$6,$F7=$F$6))) I think that I interpreted your logic correctly but you may need to mess around with it a little. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "kjguillermo" wrote: I need to return a True or False Value in Columns G and H Using the data in columns A through F. Below is an example of the data I am working with: A B C D E F G H 6 1.50 1000 128.30 1000 75.7 Help Award 7 Joe 0.00 0.00 0.00 0.00 0 8 James 5.45 1190 91.54 330 58.93 9 Jay 0.00 530 96.36 5544 69.96 10 Jack 1.21 9833 103.23 408 65.28 11 Jan 0.60 0 0.00 7633 65.38 12 Jane 1.18 3879 111.63 4591 62.68 I need Column G to indicate an employee needs "Help" (Jack as example) B10B6*.90 OR, C10C6 AND D10<D6*.90 OR, E10E6 AND F10<F6*.90 If ANY of these are true, then the employee needs help I need Column H to indicate that an emplyee gets and "Award" if they are =or< 1 in Column B, have =or 1000 in Column C AND =or 128.3 in Column D OR have =or 1000 in Column E AND =or 75.7 in Column F So employees must have 1 or less in Column B (first step) AND 1000 or over at a rate of 128.3 or Greater OR 1000 at a rate of 75.7 or Greater (second step). Thanks in advance for your help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Functions
Martin... You ARE the Man. Thanks for your assistance!!!
"Martin Fishlock" wrote: Try these two formulas and copy them down. G7=OR($B7$B$6*0.9,AND($C7$C$6,$D7<$D$6*0.9),AND( $E7$E$6,$F7<$F$6*0/9)) H7=AND($B7<=1,OR(AND($C7=$C$6,$D7=$D$6),AND($E7 =$E$6,$F7=$F$6))) I think that I interpreted your logic correctly but you may need to mess around with it a little. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "kjguillermo" wrote: I need to return a True or False Value in Columns G and H Using the data in columns A through F. Below is an example of the data I am working with: A B C D E F G H 6 1.50 1000 128.30 1000 75.7 Help Award 7 Joe 0.00 0.00 0.00 0.00 0 8 James 5.45 1190 91.54 330 58.93 9 Jay 0.00 530 96.36 5544 69.96 10 Jack 1.21 9833 103.23 408 65.28 11 Jan 0.60 0 0.00 7633 65.38 12 Jane 1.18 3879 111.63 4591 62.68 I need Column G to indicate an employee needs "Help" (Jack as example) B10B6*.90 OR, C10C6 AND D10<D6*.90 OR, E10E6 AND F10<F6*.90 If ANY of these are true, then the employee needs help I need Column H to indicate that an emplyee gets and "Award" if they are =or< 1 in Column B, have =or 1000 in Column C AND =or 128.3 in Column D OR have =or 1000 in Column E AND =or 75.7 in Column F So employees must have 1 or less in Column B (first step) AND 1000 or over at a rate of 128.3 or Greater OR 1000 at a rate of 75.7 or Greater (second step). Thanks in advance for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Functions In One Column | Excel Worksheet Functions | |||
How do I use multiple functions? | Excel Worksheet Functions | |||
Multiple Functions | Excel Worksheet Functions | |||
Using functions to calculate multiple scores according to their level of difficulty | Excel Worksheet Functions | |||
Multiple functions in one cell | Excel Worksheet Functions |