Forum Discussion
Solved
Auto filling fields and calculations
Hello All, I'm hoping this is an easy question for the Excel vet's but I'm going round in circles and would appreciate your help. I have a simple spreadsheet being used to record credits and debi...
- Hello Mark,
Assuming your Table Labels are in A1:E1, your formulas you need are:
A2=IF(C1="Card",A1,"")
B2=IF(C1="Card","Card Fees","")
C2=IF(C1="Card","Electronic","")
D2=IF(C1="Card",E1*0.0175,"")
Hi Eva, Thank you for taking the time to look at this problem.
I'm not sure why Taiwanese formatting is there as I have never used this language. Also, I did not copy and paste the table, I manually typed it into the message screen to look similar to my Excel page.
It's been a long time since I have had to use VLookup but I think I understand what you are saying.
Thank you again for your advice.
Regards,
Mark.
Hi Mark,
sorry. There was an issue on my own excel app to cause that cell formatting trouble within my sheets..., was my fault. Say, if it works so far with the vlookup. It could be easier to remind some good tricks like the tutorials about it on youtubes channel called "ExcelIsFun", check this out!
Greets, Eva.