Ifs and Ands - I'm confused!
 

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?

Ifs and Ands - I'm confused!
 

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

Ifs and Ands - I'm confused!
 

"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)

Ifs and Ands - I'm confused!
 

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" wrote in
message ...

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