Formula

  • Thread starter Thread starter agungf84
  • Start date Start date
A

agungf84

Hi all,

I am new to this website and am wondering if anybody can help me. I
want to form a formula that if number 6000,4000,2000, or 0 appear, that
it will produce 20000.

Thanks!

Cheers,
Agung
 
Not sure if this is the most elegant solution, but it will work

Assuming your data is in cell A1

=IF(OR(A1=2000,A1=4000,A1=6000,A1=0),2000,A1)

Matt
 
You must log in or register to reply here.

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 Problem 5
Indirect worksheet lookup in long formula 3
Sumif and Specified Ranges 2
Formula causing run-time error in Excel Programming 2
Formula Help 5
Formula for calculating YTD values 3
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
Help with formula 4

Back
Top