Ifs and Ands - I'm confused!

[C Tate]

I have a spreadsheet with 5 columns. Column C is Region and D is revenue. If
C is East and D is less than 10 (£000), then project increase in E is 8%,
otherwise everything is unchanged. I can do one condition with an if
statement but I need an 'and' in there too, I think, in order to be able to
work out a proper logical function!! Can anyone help?

[SteveG]

You can combine the AND and IF formulas. Not sure if you want the formula to multiply a value by 8% but you could modify this to suit your needs.

=IF(AND(C1="East",D1<10),8%,"")

or

=IF(AND(C1="East",D1<10),A1*8%,A1)

Again, not sure if you want to display the 8% or a value times it.


Does that help?

Steve

[[email protected]]

"C Tate" wrote:
> I have a spreadsheet with 5 columns. Column C is Region
> and D is revenue. If C is East and D is less than 10 (£000),
> then project increase in E is 8%, otherwise everything is
> unchanged.

=if(and(C2="East",D2<10),D2*(1+8%),D2)

[C Tate]

Many thanks. That's great guys. Is there anywhere on the net I can read
about how to combine these and and ifs myself?
"SteveG" <[email protected]> wrote in
message news:[email protected]...
>
> You can combine the AND and IF formulas. Not sure if you want the
> formula to multiply a value by 8% but you could modify this to suit
> your needs.
>
> =IF(AND(C1="East",D1<10),8%,"")
>
> or
>
> =IF(AND(C1="East",D1<10),A1*8%,A1)
>
> Again, not sure if you want to display the 8% or a value times it.
>
>
> Does that help?
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile:
> http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=515442
>