If Statements

[burkey]

Hi all

I am new to this, can someone, please help me with this.

I wont to now how to evaluate two or more logical conditions if they
are true or false using if functions for example.

If total purchases in A2 are greater than $7000.00 deduct 15% from
those purchases and if purchases are greater than $5000.00 deduct 10%
of purchases otherwise purchases stay the same.

How would I do this if funtion, Please, maybe use a or somehow?

Cheers
Mark

 

[duane]

=if(a2>7000,a2*0.85,if(a2>5000,a2*0.9,a2))

 

[burkey]

Hi Duane

Thanks I will give it a try.

Cheers
Burke