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,"")
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,"")
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,"")
