Coulkd someone help me correct this please?

[cdpaul]

I'm trying to modify this field which currently gives a positive result if over or = to 3, then minus 2%. I want it to give a positive result for 3 or over, and equal if exactly 2 with no minus 2%.

=IF(ISBLANK(I5),"",IF(K5>=3,(M5*(G5-1))*0.98,-M5))

I would be really grateful for assistance as my modification attempts keep getting errors

Thank you
Paul

 

[AlanY]

a shot in the dark

=IF(ISBLANK(I5),"",IF(K5=2,M5*(G5-1),K5>=3,(M5*(G5-1))*0.98,-M5))

 

[cdpaul]

a shot in the dark

=IF(ISBLANK(I5),"",IF(K5=2,M5*(G5-1),K5>=3,(M5*(G5-1))*0.98,-M5))

Error: You've entered too many arguments for this function

 

[AlanY]

my bad, another shot

=IF(ISBLANK(I5),"",IF(K5>=3,(M5*(G5-1))*0.98,IF(K5=2,M5*(G5-1),-M5)))

 

[cdpaul]

my bad, another shot

=IF(ISBLANK(I5),"",IF(K5>=3,(M5*(G5-1))*0.98,IF(K5=2,M5*(G5-1),-M5)))

Thanks for your help, this almost got me what I want but I maybe need to explain a little more what I'm trying to do.

Based on M5 being £10.00:

If K5=2 then result is £0.00
If K5>=3 then result is £9.80
If K5<=1 then result is -£10.00

The formula above is giving £10.00 when K5=2, but otherwise it's correct.

Hope that makes sense

 

[AlanY]

Thanks for your help, this almost got me what I want but I maybe need to explain a little more what I'm trying to do.

Based on M5 being £10.00:

If K5=2 then result is £0.00
If K5>=3 then result is £9.80
If K5<=1 then result is -£10.00

The formula above is giving £10.00 when K5=2, but otherwise it's correct.

Hope that makes sense

so, G5 doesn't comes into it then?

what if K5=1.5 or 2.5 ,say?

if K5 only in 0, 1, 2, 3 .. etc , try this

=IF(ISBLANK(I5),"",IF(K5>=3,M5*0.98,IF(K5=2,0,-M5)))

 

[cdpaul]

so, G5 doesn't comes into it then?

what if K5=1.5 or 2.5 ,say?

if K5 only in 0, 1, 2, 3 .. etc , try this

=IF(ISBLANK(I5),"",IF(K5>=3,M5*0.98,IF(K5=2,0,-M5)))

Yes I need G5, the whole formula works except if K5 =2 it should read as £0.00 and it's reading as £10.00. Only inputting whole numbers so cannot have 1.5, 2.5 etc..

 

[AlanY]

ok, one more go

=IF(ISBLANK(I5),"",IF(K5>=3,M5*(G5-1)*0.98,IF(K5=2,0,-M5*(G5-1))))

 

[cdpaul]

ok, one more go

=IF(ISBLANK(I5),"",IF(K5>=3,M5*(G5-1)*0.98,IF(K5=2,0,-M5*(G5-1))))

Fabulous, thank you very much

 

[AlanY]

you're welcome
glad that we got it sorted