Excel IF function
 

I want to use the IF function where a reserve is calculated using one of two
different calculations, but not both. I want the cell to give me an error
response if both source calculations are greater than 0 (to show that an
input error was made). I want the cell to give me a calculated amount if one
of the calculations is used properly. I would like to use as few cells as
possible to accomplish this.

=(A1*B1)0

HTH. Best wishes Harald

"Brian" skrev i melding
...
I want to use the IF function where a reserve is calculated using one of
two
different calculations, but not both. I want the cell to give me an error
response if both source calculations are greater than 0 (to show that an
input error was made). I want the cell to give me a calculated amount if
one
of the calculations is used properly. I would like to use as few cells as
possible to accomplish this.

=IF(AND(A10,B1),"Error",IF(A10,A1,B1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
I want to use the IF function where a reserve is calculated using one of
two
different calculations, but not both. I want the cell to give me an error
response if both source calculations are greater than 0 (to show that an
input error was made). I want the cell to give me a calculated amount if
one
of the calculations is used properly. I would like to use as few cells as
possible to accomplish this.

Hi Bob
smally typo :-)
=IF(AND(A10,B10),"Error",IF(A10,A1,B1))

--
Regards
Frank Kabel
Frankfurt, Germany

"Bob Phillips" schrieb im
Newsbeitrag ...
=IF(AND(A10,B1),"Error",IF(A10,A1,B1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
I want to use the IF function where a reserve is calculated using
one of
two
different calculations, but not both. I want the cell to give me
an error
response if both source calculations are greater than 0 (to show
that an
input error was made). I want the cell to give me a calculated
amount if
one
of the calculations is used properly. I would like to use as few
cells as
possible to accomplish this.

Thanks Frank :-)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Frank Kabel" wrote in message
...
Hi Bob
smally typo :-)
=IF(AND(A10,B10),"Error",IF(A10,A1,B1))

--
Regards
Frank Kabel
Frankfurt, Germany

"Bob Phillips" schrieb im
Newsbeitrag ...
=IF(AND(A10,B1),"Error",IF(A10,A1,B1))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
I want to use the IF function where a reserve is calculated using
one of
two
different calculations, but not both. I want the cell to give me
an error
response if both source calculations are greater than 0 (to show
that an
input error was made). I want the cell to give me a calculated
amount if
one
of the calculations is used properly. I would like to use as few
cells as
possible to accomplish this.