Results 1 to 5 of 5

Using IF function or similar function

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2023
    Location
    srilanka
    MS-Off Ver
    Ms office professional 2019
    Posts
    3

    Using IF function or similar function

    I have to make excel sheet for steel weight record which transport using 4 different trucks and truck numbers and their empty weights are as shown

    Truck No Empt. Wgt. (Kg) Truck No Empt. Wgt. (Kg) Truck No Empt. Wgt. (Kg) Truck No Empt. Wgt. (Kg)
    LY-3618 15300 LY-4098 17290 LY-3486 13470 LY-2974 13010

    Date Location Truck No. Ticket No. weight with Steel Weight of Steel


    I have empty truck weight and weight with steel . So i want to fill weight of steel column ( weight of truck with steel - weight of empty truck ) for this , I need formula to weight of steel column when i enter truck number and weight of truck with steel the formula should calculate deducting relevant weight of empty truck

    example
    if I enter LY-3618 weight of steel should calculate deducting 15300 kg from truck weight with steel xxxx kg ( xxxxkg - 15300 = yyyy kg
    if I enter LY-4098 formula should calculate truck weight with steel www kg - 17290 kg = zzzzkg

    Please help thank you
    Attached Files Attached Files
    Last edited by prabhathjp; 08-17-2023 at 03:04 AM. Reason: no attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Any other function similar to match function in excel
    By tej1000 in forum Excel General
    Replies: 3
    Last Post: 11-23-2022, 03:42 AM
  2. [SOLVED] Function similar to INDIRECT() ?
    By creynolds722 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2013, 10:45 AM
  3. Improve this function and create a similar function
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 08:23 AM
  4. Is there a function similar to MAX for text?
    By d14nem in forum Excel General
    Replies: 3
    Last Post: 05-18-2011, 10:32 AM
  5. Need a Function Similar to LEFT / MID / RIGHT
    By dvent in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-08-2008, 08:36 AM
  6. repeating a similar function
    By robin.a in forum Excel General
    Replies: 3
    Last Post: 04-13-2007, 07:23 AM
  7. SumIF, or similar function
    By cahrynn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2006, 08:11 AM

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