Multiple IF AND function to assign discounts

Hi All,

Hope you are doing well!...I am trying to use multiple to assign discounts and the function is not working properly...Can you please help here..Attached the workbook

Following is the function that I use

=IF(AND(C5=" ",A5>0,A5<=0.05),0.1,IF(AND(C5=" ",A5>0.05),A5,IF(AND(C5=" ",A5<=0),0.1,C5)))

I am trying to get the output in column B as

if column A has >0 and <-0.05 then 0.1 provided Column C is blank

if Column A has >0.05 then value in column A provided column C is blank

If column A has <=0 then 0.1 provided column c is blank

if column C is not blank then value in column C

But in my output only last condition "if column C is not blank then value in column C" is working..can you please help here..



Thanks,
Arun

You are not testing for C5 being blank - you have this three times in your formula:

C5=" "

but it should be:

C5=""

with nothing between the quotes - you have a space, so you need to delete that (3 times) then copy your formula down.

Hope this helps.

Pete

Thanks Pete!