Odd Question

  • Thread starter Thread starter shua
  • Start date Start date
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
 
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.
 
Back
Top