Hi There are no attachments.
From your data, there are no differences whether you round them or not. Normally I would round if the formula involves a division.
No problem
Just use =VLOOKUP(E10,$E$38:$J$65,6,FALSE)*-N10
Hi Ben Thank you
Hi rathanak your post did require for the total received in 2014. "Query if i rent motor series 2014 how can i calculate total amount received if ...
Sorry, I forgot to mention =SUMIF(B5:B21,O25,P5:P21) where O25 in your year e.g. 2014.
Hi Amy A VLOOKUP should solve your problem. Try this : In cell Z10 enter =IF(VLOOKUP(E10,$E$38:$J$65,6,FALSE)="Yes",5%,0)*-N10 A more preferr...
Hi rathanak The formulas in your file seems inconsistent, especially columns H, N and O. Even the values in E35:G39 is not what you described in po...
Hi Shelley When you click on an option button , the other options within that group will be automatically unchecked. Since you hit an error due ...
In certain situation, shading may not be useful, especially when you need to print the form (as in my case). I normally use the lightest shade of g...
Glad to be able to help out
Can you see if this is what you want?
Can I say that if D is 1 it turns grey but if E also have a 2, it will override with yellow? So you may have D=1 and E=2 and possibly F=3 all fille...
Hi Are all the colored cells in column A?