+ Reply to Thread
Results 1 to 2 of 2

Stuck on Formula for borrowing

  1. #1
    Registered User
    Join Date
    09-21-2020
    Location
    TN
    MS-Off Ver
    2019
    Posts
    1

    Stuck on Formula for borrowing

    I'm in school learning Excel, but I am stuck on this problem. I don't want an answer, but if someone can get me unstuck, that would be great.

    "Add a formula to cell B9 to calculate the amount to borrow (total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet the cash available) if the value in cell B8 is yes. If the value in cell B8 is not yes, the cell should display 0."

    How do I go about this formula?

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    6,504

    Re: Stuck on Formula for borrowing

    (total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet the cash available)
    I assume these are known cells on the different sheets and just a simple addition , using the reference to the sheet
    to view another cell on a different sheet
    SheetName!CellName

    then you need a IF()
    IF( Test , DO IF THE TEST IS TRUE, DO IF TEST IS FALSE)

    so the TEST is to see if B8 contains the value 'YES"

    IF( TEST , Calculation from Sheets, 0 )

    should help
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stuck at work and stuck on a count function
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 12:47 AM
  2. Stuck! Please help with formula
    By mcrubbin in forum Excel General
    Replies: 3
    Last Post: 05-15-2012, 06:07 PM
  3. Stuck with SUM formula
    By JRose120 in forum Excel General
    Replies: 3
    Last Post: 05-29-2009, 09:14 AM
  4. Stuck on a formula!
    By NicciB in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2008, 01:28 PM
  5. Replies: 0
    Last Post: 08-03-2006, 03:10 AM
  6. [SOLVED] stuck for a formula
    By busta in forum Excel General
    Replies: 3
    Last Post: 01-31-2006, 05:40 PM
  7. A borrowing dvd spreadsheet
    By michelleakalovey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2005, 07:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1