IF function with multiple formilae

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do an IF function with multiple formulae. Example in words. If
A1=0 then C3=0, if A1=<0 C3=B1, and if A1>0 C3=B2. a bit complicated i think,
maybe i'm missing an obvious equation. Any help greatly received.
 

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

If function across sheets prints value of cell 4
Linking cell ranges between rows and columns 1
how can i set up multiple conditional formulas in excel? 15
IF function help 4
someone please shorten this formula... 6
Rounding Error when Calculating similar times 3
sums of range within sumproduct 4
Copy Excel functions formula and auto refresh refresh 3

Back
Top