If, then formula

  • Thread starter Thread starter Kelley
  • Start date Start date
K

Kelley

I have a column where each row either says 1099, Hourly
or Salary. If it says 1099 I need it to put ".01" in a
cell, if it says Hourly I need it to put .10 in a cell
etc... What is the formula for this?
 
try this for a formula
=if(a1="1099",.01,if(a1="Hourly",.1,"Error"))
or
for each c in selection
if c="1099",c.offset(,1)=.01
else
c.offset=.1
end if
next c
 
with only three values, you can use

=IF(A1="1099",0.01,IF(A1="Hourly", .10, 1.00))

A more general approach would be to make a lookup table:


J K
1 1099 0.01
2 Hourly 0.10
3 Salary 1.00

and use:

=VLOOKUP(A1,J:K,2,FALSE)
 
Perfect! Thank you so much!!!
-----Original Message-----
with only three values, you can use

=IF(A1="1099",0.01,IF(A1="Hourly", .10, 1.00))

A more general approach would be to make a lookup table:


J K
1 1099 0.01
2 Hourly 0.10
3 Salary 1.00

and use:

=VLOOKUP(A1,J:K,2,FALSE)




.
Click to expand...
 
Back
Top