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 (00), 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?

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.yqcomputer.com/

View this thread: http://www.yqcomputer.com/

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" < XXXX@XXXXX.COM > wrote in

about how to combine these and and ifs myself?

"SteveG" < XXXX@XXXXX.COM > wrote in

1. Nesting IF's and AND's - a bit of help please...

2. two questions: and's inside if's and checking the return code of a program

3. IF's & AND's

5. Proper way to write a conditional statement with ands

6. SUMPRODUCT with AND's and OR's?

7. if & ands and either indirect or offset - need help fast please

8. Wireless Authentication ands Ecryption Question

12. Problem with calculations and multiple AND's in criteria

13. Sumproduct assistance - need multiple ANDs and ORs

14. WMP11 BUG: Advanced Search doesn't work with ANDs

15. USB 2.0 ands MP3

4 post • Page:**1** of **1**