×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel formula Help

Excel formula Help

Excel formula Help

(OP)
i have a formula "=IF(C20="","",IF(C20=E20,"Paid",(C20*D20)-(E20)))"..
this is my invoice form... if the 2 cells "C20 and E 20" are blank.. no data.. i want the TOTAL cell (F20) to be blank... if the TOTAL cell is equal to what is in "C20" and also "E20".. than i want it to display "Paid"...

thanks for the help

RE: Excel formula Help


hi,

"...if the 2 cells "C20 and E 20" are blank.. no data.. i want the TOTAL cell (F20) to be blank... if the TOTAL cell is equal to what is in "C20" and also "E20".. than i want it to display "Paid"... "

That request seem contradictory.  The TOTAL cell cannot be BOTH a number equal to c20 & E20 AND "PAID"  TILT!

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Excel formula Help

(OP)
Maybe i'm asking it incorreclty... i have a formula that works.. "=IF(C21=E21,"Paid", (C21*D21)-(E21))" this works great.. Now i am trying to add an additional IF function to display a blank cell in "F21" (where this function is) if there is no data in any of the above mentioned cells (C,D,E 21).i cant get it to work..
In "F21" i want it to display one of 3 things.. 1). "the sum of C,D,E,", 2). "PAID", 3). just leave the cell blank..

here is a pdf screenshot i uploaded.. hope it works correctly..
http://node1.nirvanix.com/EMoTHTuv~ZxDzYSKMMM~24vT09Gl~Bqm_Yoxcnk~EXq_9bk/FreeDrive/fd_284773/temp/excel%20copy.pdf?disposition=attachment

thanks
 

RE: Excel formula Help

Try this:
    =If(And(IsBlank(C21), IsBlank(D21), IsBlank(E21)), "", If(C21 = E21, "Paid", C21 * D21 - E21))

Note that I removed extraneous parentheses in the last section. They're not needed because Excel will always do the multiplication/division portion of a formula before it moves on to evaluating any addition/subtraction. Look up "order of operations" in Excel's help for more information.

If C21, D21 and E21 contain formulas and you want to test if they return "", then you can change the first part of the formula to:
=If(And(C21 = "", D21 = "", E21 = "")...

 

-John
    The plural of anecdote is not data

Help us help you. Please read FAQ 181-2886 before posting.

RE: Excel formula Help

(OP)
worked.. thank u for the help

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close