Search results

Hi Hui, YES!!! you came through once more, I should say thank you at least a million times, that's how long I've struggled with this simple (FOR YOU) solution. David B

Hi all, I'm back again needing your HELP PLEASE!!!!! my problem(can't seem to get the solution) is: I have a list [A6*A7+A8/A9+A10], which has 2 possible totals, [CELL A12 or CELL A13] depending on the input value in [CELL 9]. If the input is <9 then the total shows in [CELL A12] leaving...

thanks Hui, you're a ****STAR**** regards David B

I have another query, cell A28 has this statement "=IF(A19<9,"",(IF(A19>=9,A19*1.5,))+A27" what do I need to add or change, to make cell A27 blank if the value of A19>=9

thanks Hui, you saved me from going round in circles, regards David B

Hi all I need a solution please cell A19 can have different numbers (8, 9, 12, 16) entered, which gives me a result in A27. If "8" is entered the resulting value remains unaltered, if "9" is entered, "9" becomes (9*1.25). If "12" is entered, "12" becomes (12*1.5). If "16" is entered...

help please how do you do a duplicate(mirror) entry to another cell(s) without copying regards David B

Hi Hui thanks for the info, just what I needed regards David B

Hi can anyone help? I have the following statement, which gives a result in cell A26 "=(135-(A18*10)-(A19*A20)+(SUM(A21:A24)))" I would like to change the values of A19, if a specific number is entered e.g. enter 12 and it would become 18 or enter 16 and it would become 24, otherwise the...

Hi Dan many thanks for the info, it works a treat, cheers David B

hi, can you please help me, I need an "if" formula, but can't seem to understand the info given in most books. I have 5 cells A-E named Distance, Time, Race time, Diff, Going my normal calc is (D/A)*3 which gives me E I need a formula that shows 0 in E if 0 is entered in C or else shows my...