If Then Formulas

R

Renee''

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% .
 
M

Marcelo

hi,

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

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



"Renee''" escreveu:
 
D

Dave F

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

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

Dave
 
B

Bernard Liengme

=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
 
Top