Results 1 to 5 of 5

#Value Error Still Not Solved

Threaded View

  1. #1
    Forum Mmeber
    Join Date
    01-29-2011
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    5

    #Value Error Still Not Solved

    Hello I am new and need some help please

    I have a sheet say cell A1 and I wish to populate cell a20 with the value in cell a1 which will do some simple math cell e1 will be a20 x b20 however if there is no value in a1 than it comes up with value error so how can I fix that. Isnt is some kind of if = than that value else zero
    Last edited by bbheli; 01-30-2011 at 09:50 AM. Reason: Admin Told Me it was wrong

Thread Information

Users Browsing this Thread

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

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