Problem with IF function

By macx
May 9, 2009
  1. XP sp3, Excel (I think it's 2003? not the new type with Vista)

    Trying to set up a small spreadsheet that will calculate 3 numerical values
    across in the same row in columns B thru D when I enter a number value
    in the A column, but leaves the cells in B, C & D columns blank until I do
    enter the number in the A column.

    I've got an IF function working OK in the B column, showing
    nothing if there's no value in the A column.

    I can't get an IF function working in the C column essentially
    doing the same thing - only showing a value if there's a value
    in the B column, which only shows as a result of the IF function
    if I enter a value in the A column. The 1st part of my IF function
    in the C column has to be the cell reference to the calculated
    number in the B column which only happens if I enter a numerical
    value in the A column, but the error message says that I can't use
    a cell reference for that - it calls it the wrong type of data.

    I've got the IF function I want to use working OK in B column cells
    where I have entered a value in the A column and a value resulting
    from the IF function in the B column is calculated and shown in
    the B column. Then the IF function shows with no error message
    and works correctly in the C column.

    What else can I do but use a cell reference for that? There's no
    numerical value in the cell in the B column until I enter a value
    in the A column and the IF function in the B column calculates one.

    I hope I've got it explained so it's understandable?

    Thanks for any help!

    I do things like this to help me learn how to do them.
Topic Status:
Not open for further replies.

Similar Topics

Create an account or login to comment

You need to be a member in order to leave a comment
TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...

Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.