IF AND condition

  • Thread starter Thread starter Ann Shaw
  • Start date Start date
A

Ann Shaw

Hi it's little old me again from Ireland with another
problem function!!

I have Regions and revenues and I want to set a condition
with If and AND together

City Region Rev(?000) ProjIncrease(?000) 2001
Alicante South 10 In this cell I want a
Alicante South 15 formula to say
Alicante South 40 =if(and(????
Alicante South 5 so that if my region is
Amsterdam West 15 East and my Rev is < 20 I
Amsterdam West 30 want to increase rev by
8% otherwise no change.

Thanks a million

Ann
 
=IF(AND(B2="East",C2<20),C2*1.08,C2)

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh
 
Try =IF(AND(B2="East",C2<20),C2+(C2*0.08),C2)or try
=IF(AND(B2="East",C2<20),C2*0.08,"")

Charlie O'Neill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Percentage of Total for Category 6
Copying data from one workbook to another dependent on user select 1
Creating a drop down list from another drop down 2
Count unique values based on multiple criteria 2
PIVOT - refresh pivot based on Field / item 1
Sumif And Countif 7
If C2 = East AND D2 < 20,000.00 then multiply D2 by 8% 4
conditional formatting in pivot table 1

Back
Top