cud anyone fix my receipt up, i want the values to come up without saying na and add up the total with only the values selected
problem = error comes up when values are entered, total only works when all the fields are filled in, i want it to work without all the fields having to be filled in
http://aycu27.webshots.com/image/337...7474728_rs.jpg
download the excel file to try fix
Last edited by helpmex; 11-08-2007 at 12:23 PM.
Hi Helpmex
Do it like this
=IF(A21="","",VLOOKUP(B21,Price, 2, "false"))
Ed
wer do i paste it, coz it went wrong when i did it before
edit : doesnt affect it, still says na on subtotal
but the subtotal still says na
and that forumula hasnt done nothing
i have uploaded a new excel doc, please use that one
Last edited by helpmex; 11-08-2007 at 12:20 PM.
Hi,
Just a note, in your VLOOKKUP formula the FALSE statement should not be inside quotes and can also be replaced by a 0 for FALSE or 1 for TRUE.
Cheers!
Jean-Guy
im crap at excel, all i want is my sub total to appear when there is a total, it only appears when all fields are completed
anyone tell me the forumulas for my new doc i posted
Hi,
Here's one way:
in E39
but a better solution would be to get rid of the #N/A errors completly, replace the formulas in C20 and E20 with the ones below.
=SUMIF(E20:E37,"<>#N/A",E20:E37)
in C20:
in E20:=IF(A20="","",VLOOKUP(B20,Price, 2, 0))
HTH=IF(A20="","",(A20*C20)-D20)
Jean-Guy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks