formula help
in [General]
|
Prev: Excel 2007 slow changing between worksheets
Next: How can I eliminate rows that contain the same data as the row
From: mahone on 5 Jul 2008 07:38 hi i'm trying to calculate charges at different rates according to the criteria in various cells, but i'm not getting very far. example column A contains a stock figure column B contains stock to be received figure & column C contains type of stock to be received either a Y or a blank. what i need is if C contains "Y" charge B at 0.05 per unit regardless of what is in A. but if C is blank charge B at 0.025 per unit but only if A is greater than 0. hope that all makes sense & i haven't over complicated what i want to do. any help would be appreciated.
From: Pete_UK on 5 Jul 2008 07:59 Try this in D2 (assuming data starts on row 2): =IF(C2="Y",B2*0.05,IF(A2>0,B2*0.025,"")) Hope this helps. Pete On Jul 5, 12:38 pm, mahone <mah...(a)discussions.microsoft.com> wrote: > hi i'm trying to calculate charges at different rates according to the > criteria in various cells, but i'm not getting very far. example column A > contains a stock figure column B contains stock to be received figure & > column C contains type of stock to be received either a Y or a blank. what i > need is if C contains "Y" charge B at 0.05 per unit regardless of what is in > A. but if C is blank charge B at 0.025 per unit but only if A is greater than > 0. hope that all makes sense & i haven't over complicated what i want to do. > any help would be appreciated.
From: mahone on 6 Jul 2008 05:29 thanks i'll give this a go when i get back to work next week. hopefully it'll work & i'll learnt something else. "Pete_UK" wrote: > Try this in D2 (assuming data starts on row 2): > > =IF(C2="Y",B2*0.05,IF(A2>0,B2*0.025,"")) > > Hope this helps. > > Pete > > On Jul 5, 12:38 pm, mahone <mah...(a)discussions.microsoft.com> wrote: > > hi i'm trying to calculate charges at different rates according to the > > criteria in various cells, but i'm not getting very far. example column A > > contains a stock figure column B contains stock to be received figure & > > column C contains type of stock to be received either a Y or a blank. what i > > need is if C contains "Y" charge B at 0.05 per unit regardless of what is in > > A. but if C is blank charge B at 0.025 per unit but only if A is greater than > > 0. hope that all makes sense & i haven't over complicated what i want to do. > > any help would be appreciated. > >
From: Pete_UK on 6 Jul 2008 06:26 You're welcome. Pete On Jul 6, 10:29 am, mahone <mah...(a)discussions.microsoft.com> wrote: > thanks i'll give this a go when i get back to work next week. hopefully it'll > work & i'll learnt something else. >
From: mahone on 7 Jul 2008 12:41
the first part worked charging at the higher rate if there was a "Y" in column C just the last bit didn't work. it charged at the lower rate when column C was blank & there was a zero in column A instead of any quantity greater than zero. any suggestions? "Pete_UK" wrote: > You're welcome. > > Pete > > On Jul 6, 10:29 am, mahone <mah...(a)discussions.microsoft.com> wrote: > > thanks i'll give this a go when i get back to work next week. hopefully it'll > > work & i'll learnt something else. > > > |