ExcelBanter - If Then Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Then Formulas (https://www.excelbanter.com/excel-worksheet-functions/112489-if-then-formulas.html)

Renee''

If Then Formulas

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!

Kassie

If Then Formulas

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

PCLIVE

If Then Formulas

Maybe this:

=IF(A1<500000,"N.A.", A1*.01)

"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!

Marcelo

If Then Formulas

hi,

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

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

"Renee''" escreveu:

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!

Dave F

If Then Formulas

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

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

Dave
--
Brevity is the soul of wit.

"Renee''" wrote:

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!

Bernard Liengme

If Then Formulas

=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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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!

All times are GMT +1. The time now is 01:18 AM.