#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

=IF(A1="","",A20*B20) not sure what you using to do the mupliplying, but it's the Asterix from the numeric you want. This will leave a blank if there's no value in A1

Originally Posted by scottylad2

=IF(A1="","",A20*B20) not sure what you using to do the mupliplying, but it's the Asterix from the numeric you want. This will leave a blank if there's no value in A1

This returns an answer false. Let me better explain what I am trying to do.

I'm making a commission calculator where sales people can enter qty in front of item but unless each item has a zero in the quantity field I get a value error. So
A B C
QTY Commission Total
A1 B1 A1*B1 (this returns value if one of the rows has blank vs a zero


Sum c1..c50)

Therefore the sum of colum C is not totaled because it shows a value error.


A42 is a repeat of the above. A 42 will get populated by A1 value and C42 will show the total from C1. the reason is a hidden sheet to do the calculations and sales reps only see final answer
My goal is to not have to have all zeros in the row a and avoid the #value error in C, I want users to only have to enter a QTY in row A not zero in each non used field

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

It's still wrong. Thread closed try again