Need Help with IF statement.

[rm06]

Hi,

I need to do an if statement on a invoice:

If a customer has brought products over £300 he gets 10% discount.

cell for total is e20 and the cell that needs to have the sum is e21.

Thanks in advance.

[Cutter]

Maybe

=IF(E20="","",IF(E20>300,E20*.9,E20))

[rm06]

thanks it worked :D,

but sorry should have mentioned before if they dont get a discount it should say no/none given, can u help me with this?

[Spencer101]

You could merge two rows for the bit you need bigger text in and leave the other bit as it is.

Would that do what you mean?

EDIT: The post above has been edited and the bit I was responding to was deleted. That's why mine makes no sense, not because I've gone bonkers and started answering imaginary questions...

[Cutter]

Try

=IF(E20="","",IF(E20>300,E20*.9,"no/none given"))

[rm06]

You could merge two rows for the bit you need bigger text in and leave the other bit as it is.

Would that do what you mean?

EDIT: The post above has been edited and the bit I was responding to was deleted. That's why mine makes no sense, not because I've gone bonkers and started answering imaginary questions...

im sorry i accidently deleted it just realised now,

thanks for answering, eg.jpg

but as the image shows invoice is making the whole row big and i do not want that to happen, can u still help me?

[rm06]

Try

=IF(E20="","",IF(E20>300,E20*.9,"no/none given"))

thanks :D ,

so if i changed the cell do i just have to change the e20 bit?

[Spencer101]

In that example, highlight cells E1 : G2 and click that "Merge & Center" button that you can see in the top right of the pic.

Then you can shrink row 2 to fit "address" properly and resize row 1 to make "invoice" fit properly.

Hope that's what you meant...

[Cutter]

@Spencer101

The post above has been edited and the bit I was responding to was deleted. That's why mine makes no sense, not because I've gone bonkers and started answering imaginary questions...

I figured that out.

[Spencer101]

@Spencer101

I figured that out.

Glad to hear it!

Just thought I'd clarify though for anyone reading this further down the line.. Because then I really would seem a bit strange

[Cutter]

@rm06

so if i changed the cell do i just have to change the e20 bit?

Yes.

[rm06]

In that example, highlight cells E1 : G2 and click that "Merge & Center" button that you can see in the top right of the pic.

Then you can shrink row 2 to fit "address" properly and resize row 1 to make "invoice" fit properly.

Hope that's what you meant...

it didnt change it , this is what happened eg 2.jpg

[rm06]

@rm06


Yes.

ok thank you :D

[Cutter]

You're welcome.

[Spencer101]

it didnt change it , this is what happened Attachment 157629

That's because you merged A1:G2.... undo that and then just select E1:G2 and merge.

[Spencer101]

So that it looks like this...

[rm06]

its still is not doing that the whole row still goes big

thanks anyway

[rm06]

So that it looks like this...

I just saw this now, thanks il do that :D

[Spencer101]

Not a problem.

[Cutter]

@rm06
Thanks for the 'star tap'. Don't forget to mark your thread as SOLVED (click on Forum Rules @ top of page - see rule #9 for instructions, if needed).

[rm06]

yw, marked solved too