Try this in D2 (assuming data starts on row 2):

=IF(C2="Y",B2*0.05,IF(A20,B2*0.025,""))

Hope this helps.

Pete

On Jul 5, 12:38*pm, mahone 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.