Multiple functions in one cell

  • Thread starter Thread starter Arvi Laanemets
  • Start date Start date
A

Arvi Laanemets

Hi

=IF(TrueCondition,Expression1,Expression2)

Like
=IF(X1="","",SUM(A:A))

Arvi Laanemets
 
Something like

=if(B2="","",B2/A2)

the details you gave were only good to make assumptions. If this is not what
you want, post back with more details.
 
Sorry it would be

=if(B2>0,"",B2/A2)

Gaurav said:
Something like

=if(B2="","",B2/A2)

the details you gave were only good to make assumptions. If this is not
what you want, post back with more details.
Click to expand...
 
Is there a way to write a formula that will leave a cell blank if a
specified value is a positive number, but will calculate a percentage
if the value is a negative number? I know how to write these formulas
separately, but cannot seem to get it right bringing them together in
one cell. Not sure if this is even possible.
 
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

AND logical operator 5
.Net 2.0 classes very buggy? 9
bind multiple data tables from sql queries to multiple datacontainers? 1
Largest In A Range 6
Multiple IF functions 4
Summing cells based on mulitiple criteria over mulitple columns 0
FormatCondition Numeris/alpha testing 4
Accessing SQL Server Table-Valued Function from Access front-end 1

Back
Top