R Ray New Member Jun 21, 2015 #1 Sorry I can't get a grasp on writing basic formulas, I'll upload what I need help with Thanks, Ray Attachments ToolRental1.xlsx 102.9 KB · Views: 0
N NARAYANK991 Excel Ninja Jun 21, 2015 #2 Hi Ray , See if this is OK. Narayan Attachments ToolRental2.xlsx 103.2 KB · Views: 0
Syedali Active Member Jun 22, 2015 #3 Ray said: Sorry I can't get a grasp on writing basic formulas, I'll upload what I need help with Thanks, Ray Click to expand... Put this formula in J6 ="IFERROR(SUM(tblBooks[[#This Row],[Column8]]*tblBooks[[#This Row],[Column9]]),tblBooks[[#This Row],[Column9]])"
Ray said: Sorry I can't get a grasp on writing basic formulas, I'll upload what I need help with Thanks, Ray Click to expand... Put this formula in J6 ="IFERROR(SUM(tblBooks[[#This Row],[Column8]]*tblBooks[[#This Row],[Column9]]),tblBooks[[#This Row],[Column9]])"
R Ray New Member Jun 23, 2015 #4 NARAYANK991 said: Hi Ray , See if this is OK. Narayan Click to expand... Works thanks!