Solved

Excel help

Posted on 2014-07-28
8
168 Views
Last Modified: 2014-07-28
Hi,

I need help to reformulate statement below...it is returning an error..


=IF(X56 = 0,"NO ALLOWANCE"),IF(X56>=W56,"GOOD","BAD")
0
Comment
Question by:LubinofS
8 Comments
 
LVL 19

Expert Comment

by:Montoya
ID: 40225157
what is the error you are getting? What do you want to formula to do?
0
 

Author Comment

by:LubinofS
ID: 40225170
I am getting "#VALUE!"


Everytime values in column X are higher or equal than column Y I want to qualify it as "GOOD" , if not would  be "BAD" , however there would be an excepction when column X equal ZERO ( "NO ALLOWANCE" )
0
 
LVL 19

Assisted Solution

by:Montoya
Montoya earned 250 total points
ID: 40225175
=IF(A2 = 0,"NO ALLOWANCE",IF(A2>A3,"GOOD","Bad"))
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 7

Accepted Solution

by:
CorinTack earned 125 total points
ID: 40225176
=IF(X56 = 0,"NO ALLOWANCE",IF(X56>=W56,"GOOD","BAD"))

This will test cell X56. If it is zero (or blank) it will return NO ALLOWANCE. If it is not blank, but greater than (or equal to) W56, it will return GOOD, otherwise it will return BAD.

I presume this is what you were looking to accomplish.
0
 

Author Comment

by:LubinofS
ID: 40225178
Sorry, see correction below...

Everytime values in column X are higher or equal than column W I want to qualify it as "GOOD" , if not would  be "BAD" , however there would be an excepction when column X equal ZERO ( "NO ALLOWANCE" )
0
 
LVL 19

Assisted Solution

by:Montoya
Montoya earned 250 total points
ID: 40225179
basically, you didnt next your parentheses properly
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 125 total points
ID: 40225182
try this

=IF(X56 = 0,"NO ALLOWANCE",IF(X56>=W56,"GOOD","BAD"))
0
 

Author Comment

by:LubinofS
ID: 40225188
I got it, thanks to all...
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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…

830 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