If Then Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Afternoon.
Can anyone tell me how to write a formula that
puts 'N.A.' in a cell if the number in the previous cell is less than
$500,000.
If the value in the previous cell $500,000. or more then calculate 1% .
 
hi,

=if(a2<500000,"N.A.",a2*1%)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Renee''" escreveu:
 
=IF(A1<500,000,"N/A",A1*.01)

Assumes "previous cell" is A1. Modify to suit your needs.

Dave
 
=IF(A1<500000,N/A, A1*1%)
or
=IF(A1<500000,"N.A", A1*1%)

where A1 is the cell with the value to be tested - you can change the
address to match you needs.
best wishes
 
Back
Top