IF statements/formula problem

[Admiral70]

I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.

 

[Morrigan]

=IF(C>0,A,A/2)

I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.

 

[Duke Carey]

=A2/if(c>0,2,1)

 

[Duke Carey]

=a1/if(c1>0,2,1)

apologies if this came through 2 times

 

[db]

Admiral -
This will work for the first row, drag down for however far you need the
range to be:

=IF(C1>0,A1,A1/2)

 

[db]

Duke -
I believe you have the 2 and the 1 switched around in your formula, it
should be:

=a1/if(c1>0,1,2)

 

[Admiral70]

Thanks for such a quick response. I think this will work for what I
need.

Thanks again.

 

[Admiral70]

This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show
a - (dash)?

=IF(K28>0,G28,G28/2)

 

[db]

I'm a little confused by what you mean. Do you mean as it stands now Excel
is showing parenthesis for negative numbers? For example:

It is showing: ($40.45)
You want it to show: $-40.45

 

[Admiral70]

This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show

a - (dash)?


=IF(K28>0,G28,G28/2)


Any ideas? Thanks

 

[Admiral70]

No, sorry, if it shows ($40.45) then I want to show just a - no # at
all, not even a zero.

Thanks for clarifying.

 

[Sandy Mann]

Try:

=IF(G28<0,0,IF(K28>0,G28,G28/2))

and format the cell as Accounting with no currency sign if necessary but
note that the value stored in the cell will now be zero.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[db]

Just a little update to this formula, you can do the same thing without
having to format it as accounting:

=IF(G28<0,"-",IF(K28>0,G28,G28/2))

 

[Admiral70]

Ok, so the number is zero, but will show a dash. Is the dash part of
the Accounting format?

Thanks

 

[Sandy Mann]

Yes I did think of suggesting that but is the cell is referenced in a
formula it will cause the formula to return #VALUE!

--
Regards

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Sandy Mann]

Yes, in Accounting format a zero is shown as a dash.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk