Multiple functions in one cell

A

Arvi Laanemets

Hi

=IF(TrueCondition,Expression1,Expression2)

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

Arvi Laanemets
 
G

Gaurav

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.
 
G

Gaurav

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...
 
C

cgroninger

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.
 

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
Multiple IF functions 4
Tracked changes by multiple people modified to one 0
Accessing SQL Server Table-Valued Function from Access front-end 1
enterprise fields 0
FormatCondition Numeris/alpha testing 4
Largest In A Range 6
Multiple formats in one cell 1

Top