IF Function

R

ruthyeh

New Member
Joined
Mar 21, 2013
Messages
2
Hi,
I have this IF function so far - =IF(AND((B9>B8),(B9>B10)),"peak"," ")
My question is can I make it so that it basically says 'If B9 is 50% bigger than B8, and B9 50% bigger than B10'??
Please help!!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
This is for exactly 50% larger:
=IF(AND(B9=1.5*B8,B9=1.5*B10),"peak,"")

This is for 50% or more:
=IF(AND(B9>=1.5*B8,B9>=1.5*B10),"peak","")
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Using Cell Value to Identify "Print To" Folder with If Then ElseIf
Replies
2
Views
154
reberryjr
R
J
  • Solved
No formulas working to rename sheets within workbook
Replies
9
Views
151
Joe4
Joe4
F
  • Question
Formula required
Replies
6
Views
321
FormR
FormR
A
  • Solved
VBA Code to Add a Comment to a Cell based on that Cells Content
2
Replies
11
Views
184
albert_de
A
J
  • Solved
Formula to calculate desired profit margin, Acurately without Solver
Replies
7
Views
970
6StringJazzer
6StringJazzer

Forum statistics

Threads
1,214,960
Messages
6,122,479
Members
449,088
Latest member
Melvetica

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top