=IF(C8="","",IF(C8<500000,"N.A.",C8*0.01))

--
kassie

never stop learning




"Renee''" wrote in message
...
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% .
--
Thanks!