Solved

nested if

Posted on 2016-11-01
11
42 Views
Last Modified: 2016-11-01
=If(Y1160=AB1160,Y1160),If(Y1160=AB1160,Y1160),AE1160

please help me out i need value a nested if

this have an error
0
Comment
Question by:edo60
  • 5
  • 4
  • 2
11 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41869360
Both your conditions are the same, so you don't need a nested IF. This looks like it will suffice...

=IF(Y1160=AB1160, Y1160, AE1160)
0
 

Author Comment

by:edo60
ID: 41869363
not the same
compare 3 diferent values
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41869365
You'll need to describe what you want the formula to do then. What 3 values are to be compared? Your proto-formula is checking if Y1160=AB1160 twice.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:edo60
ID: 41869368
ok

bajas    bajas   bajas  bajas      result          bajas

bajas altas   bajas  bajas      result            false

altas altas altas  altas       result    altas

altas bajas altas altas     result    false


Regards!!!
0
 
LVL 22

Expert Comment

by:yo_bee
ID: 41869369
@EDO
Your if statement is not correctly structured

Nested IF should be soothing like this:

=If(A1=<something>,If(B2=<something> else,"Both are true","A1 is true, but B2 is false"),"A1 is false so B2 has to be false)

Open in new window

0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 250 total points
ID: 41869372
So comparing 4 values, not 3? And if all values are the same, return that value, otherwise return FALSE? You don't need a nested IF formula then. Use COUNTIF to check that all 4 are the same...

=IF(COUNTIF(A2:D2,A2)=4, A2)

See the attached workbook for an example.
COUNTIF.xlsx
0
 
LVL 22

Assisted Solution

by:yo_bee
yo_bee earned 250 total points
ID: 41869374
Try this
=IF(AND(A12=B12,B12=C12,C12=D12),A12,FALSE)

Open in new window

0
 

Author Comment

by:edo60
ID: 41869400
wayne,
thats the idea but there are not consecutive values
how to achive
regards
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41869402
In that case you will be best using edo60's method.
0
 

Author Comment

by:edo60
ID: 41869413
im gona copy them together
0
 

Author Closing Comment

by:edo60
ID: 41869478
Tsm you experts!
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
modify formula same cell multiple times 15 29
Excel 2013: Default workbook 13 29
Excel Formula 16 44
sort column using vba 2 17
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question