Need Help with IF statement.

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.

Maybe

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

Try

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

Originally Posted by 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...

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?

Originally Posted by Cutter

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?

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...

@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.

Originally Posted by Cutter

@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

@rm06

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

Yes.

Originally Posted by 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...

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

Originally Posted by Cutter

@rm06


Yes.

ok thank you :D

You're welcome.

Originally Posted by rm06

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.

So that it looks like this...

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

thanks anyway

Originally Posted by Spencer101

So that it looks like this...

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

Not a problem.

@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).

yw, marked solved too