Guys, need some help with the following formula....
=CONCATENATE(IF('Shed Enquiry - Page 1'!$B$21>0,CONCATENATE('Shed Enquiry - Page 1'!$G$21," x ",'Shed Enquiry - Page 1'!$B$21," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$21,"]"," - ",'Shed Enquiry - Page 1'!$I$21," (",'Shed Enquiry - Page 1'!$K$21,"), "),""),IF('Shed Enquiry - Page 1'!$B$22>0,CONCATENATE('Shed Enquiry - Page 1'!$G$22," x ",'Shed Enquiry - Page 1'!$B$22," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$22,"]"," - ",'Shed Enquiry - Page 1'!$I$22," (",'Shed Enquiry - Page 1'!$K$22,"), "),""),IF('Shed Enquiry - Page 1'!$B$23>0,CONCATENATE('Shed Enquiry - Page 1'!$G$23," x ",'Shed Enquiry - Page 1'!$B$23," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$23,"]"," - ",'Shed Enquiry - Page 1'!$I$23," (",'Shed Enquiry - Page 1'!$K$23,"), "),""),IF('Shed Enquiry - Page 1'!$B$24>0,CONCATENATE('Shed Enquiry - Page 1'!$G$24," x ",'Shed Enquiry - Page 1'!$B$24," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$24,"]"," - ",'Shed Enquiry - Page 1'!$I$24," (",'Shed Enquiry - Page 1'!$K$24,")")," "))
Whilst this forumla works fine, I'm trying to bundle it into a IF argument, but can't seem to get both the True and False parts to work.
In the original CONCATENATE formula, the IF argument false value was "" which is giving me some trouble.
How can i get the above formula to work with an IF argument?
=CONCATENATE(IF('Shed Enquiry - Page 1'!$B$21>0,CONCATENATE('Shed Enquiry - Page 1'!$G$21," x ",'Shed Enquiry - Page 1'!$B$21," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$21,"]"," - ",'Shed Enquiry - Page 1'!$I$21," (",'Shed Enquiry - Page 1'!$K$21,"), "),""),IF('Shed Enquiry - Page 1'!$B$22>0,CONCATENATE('Shed Enquiry - Page 1'!$G$22," x ",'Shed Enquiry - Page 1'!$B$22," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$22,"]"," - ",'Shed Enquiry - Page 1'!$I$22," (",'Shed Enquiry - Page 1'!$K$22,"), "),""),IF('Shed Enquiry - Page 1'!$B$23>0,CONCATENATE('Shed Enquiry - Page 1'!$G$23," x ",'Shed Enquiry - Page 1'!$B$23," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$23,"]"," - ",'Shed Enquiry - Page 1'!$I$23," (",'Shed Enquiry - Page 1'!$K$23,"), "),""),IF('Shed Enquiry - Page 1'!$B$24>0,CONCATENATE('Shed Enquiry - Page 1'!$G$24," x ",'Shed Enquiry - Page 1'!$B$24," [","Motor:"," ",'Shed Enquiry - Page 1'!$E$24,"]"," - ",'Shed Enquiry - Page 1'!$I$24," (",'Shed Enquiry - Page 1'!$K$24,")")," "))
Whilst this forumla works fine, I'm trying to bundle it into a IF argument, but can't seem to get both the True and False parts to work.
In the original CONCATENATE formula, the IF argument false value was "" which is giving me some trouble.
How can i get the above formula to work with an IF argument?