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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula using "lesser of" 3
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column 3
Help with IF function 3
IF(AND) function? 5
IF function Between 1
EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge 3
Difficult Formula 2
Calculating Percentage Rent 4

Back
Top