+ Reply to Thread
Results 1 to 2 of 2

Can not use formula with formular column

  1. #1
    Forum Contributor
    Join Date
    03-05-2015
    Location
    Cambodia
    MS-Off Ver
    2016
    Posts
    120

    Can not use formula with formular column

    every column have formula and I want to calulate another column which is take from that column but it was error.

    Example:
    Column A: I got data by using this formular IF(COUNTA($I6)>=1,$I6-48,"") and we got data ( 5 Jun)
    Column B, row 1: i use this formula IF(COUNTA(A)>=1,A-7,"") it work but row 2 it show this "#VALUE!" unless I have value in column A row 2.

    I want column B blank when A column no value and it would be automatic calculate when A column have value.

    Thanks you in advance for your guys help.
    Leakhna
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Can not use formula with formular column

    =iferror(if(counta(a5)>=1,a5+7,""),"")

+ 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. Complicated formular. Formular, remove text if available
    By TheTrooper1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2014, 12:39 PM
  2. [SOLVED] Replacing a date formular result with another formular
    By stpeter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2013, 06:27 PM
  3. copying a formular in a colums to a last row used in another column
    By stevekirk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2012, 03:48 AM
  4. Replies: 1
    Last Post: 10-20-2006, 05:24 AM
  5. [SOLVED] formula-Statistics formular
    By richespresentation in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-11-2005, 03:06 PM

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