Solved

Excel help

Posted on 2014-07-28
8
163 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:Iammontoya
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:Iammontoya
Iammontoya earned 250 total points
ID: 40225175
=IF(A2 = 0,"NO ALLOWANCE",IF(A2>A3,"GOOD","Bad"))
0
 
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

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:Iammontoya
Iammontoya earned 250 total points
ID: 40225179
basically, you didnt next your parentheses properly
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
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…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now