Credit Limit 1200, Charge 150, i need an "if function" that returns if the persons current charges are greater than or equal to 70% of their current limit they will be designated as "preferred" --not meeting criteria will designate as "annual Fee" function parameters are If(logical_test, value if true, value if false) cant get the logical test part to come back with an answer...
2006-12-07 17:40:57 · 2 answers · asked by nick pappa G 1 in Science & Mathematics ➔ Mathematics
You haven't given any cell references for where these values can be found so I will be generic. Create a cell with the formula for the ratio r.
r = "Charge"/"Credit Limit"
=IF(r>=.7,"preferred","annual Fee")
2006-12-07 17:59:40 · answer #1 · answered by Northstar 7 · 0⤊ 0⤋
if(x>=.7, 'preferred', 'annual fee')
2006-12-07 17:53:11 · answer #2 · answered by arj7002 2 · 0⤊ 0⤋