Odd Question

S

shua

I want to setup one formula if I can that does the following...

If A1 => 200 Apply Forumla A. If A1 < 200 Apply Formula B.

I would like to do it in one line if possible so I don't have to have
two boxes and some confusion.

Thanks
 
D

Dave R.

That's not odd!

look up the IF formula in help, by pressing F1. Read all about it. It'll be
something like
=+IF(A1>=200,20+A1,IF(A1<200,25+A1))

keep in mind that if A1 is blank it can be seen as 0 and you'll get the
answer 25.
 

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

Top