Forum Discussion
Re: Fields do not display data correctly
I hope that someone will be able to help me with these issues.
I have a spreadsheet setup as:
Equipment = dropdown to select equipment
Formula = None
B31 Quantity = user entry
Formula = None
E31 Cost Each = vlookup from "29-Data" sheet
Formula = =IF(ISERROR(VLOOKUP($B$31,'29-Data'!A12:E50,5,FALSE)),"",(VLOOKUP($B$31,'29-Data'!A12:E50,5,FALSE)))
F31 Final Cost = the total of B31*E31 )
Formula = PRODUCT(E31,D31)
Problem: this fields is multiplying B31*E31, but when there is no quantity entered the F31 field still displays the amount from the lookup. Should only have amount if there is quantity entered.
Please see attached spreadsheet.
Thank you in advance,
Yvette
Hello,
try this in F31 and copy down:
=IF(ISNUMBER(D31),PRODUCT(E31,D31),"")
cheers, teylyn
Hello,
try this in F31 and copy down:
=IF(ISNUMBER(D31),PRODUCT(E31,D31),"")
cheers, teylyn
Thank you Teylyn very much, it works.
Is there a way to make sure that the text populates in Quantity field:D3?
Thanks again in advance,
Yvette
