Conditional Formula
 

I am pretty new to formula so help please. I want to condition a formula to
add down a column then add across a row and if = return the number otherwise
false.

=SUM(E16*7.75%)=SUM(B18:D18)

I have it returning true now but want it to return number or false if not
equal

Thank you for the help.

Donna

Conditional Formula
 

=IF(SUM(E16*7.75%)=SUM(B18:D18),SUM(B18:D18),"FALS E")

"Donna" wrote:

I am pretty new to formula so help please. I want to condition a formula to
add down a column then add across a row and if = return the number otherwise
false.

=SUM(E16*7.75%)=SUM(B18:D18)

I have it returning true now but want it to return number or false if not
equal

Thank you for the help.

Donna

Conditional Formula
 

Maybe


=IF(E16*7.75%=SUM(B18:D18),TRUE,FALSE)

Mike

"Donna" wrote:

I am pretty new to formula so help please. I want to condition a formula to
add down a column then add across a row and if = return the number otherwise
false.

=SUM(E16*7.75%)=SUM(B18:D18)

I have it returning true now but want it to return number or false if not
equal

Thank you for the help.

Donna

Conditional Formula
 

=IF(E16*7.75%=SUM(B18:D18),E16*7.75%)

Note that you don't need SUM() around the E16*7.75%.
--
David Biddulph

"Donna" wrote in message
...
I am pretty new to formula so help please. I want to condition a formula
to
add down a column then add across a row and if = return the number
otherwise
false.

=SUM(E16*7.75%)=SUM(B18:D18)

I have it returning true now but want it to return number or false if not
equal

Thank you for the help.

Donna

Conditional Formula
 

hi
i'm having a bit of trouble understanding.
i see your fomula reading down a column but i don't see it reading across a
row unless you mean e16.
another thing ...what number??

=if(SUM(E16*7.75%)=SUM(B18:D18),"number", "False")

the above formala will do as you wish but it's the number part we need to
claify.

Regards
FSt1

"Donna" wrote:

I am pretty new to formula so help please. I want to condition a formula to
add down a column then add across a row and if = return the number otherwise
false.

=SUM(E16*7.75%)=SUM(B18:D18)

I have it returning true now but want it to return number or false if not
equal

Thank you for the help.

Donna

Conditional Formula
 

Thank you that worked perfectly and it makes sense.

"Sean Timmons" wrote:

=IF(SUM(E16*7.75%)=SUM(B18:D18),SUM(B18:D18),"FALS E")

"Donna" wrote:

I am pretty new to formula so help please. I want to condition a formula to
add down a column then add across a row and if = return the number otherwise
false.

=SUM(E16*7.75%)=SUM(B18:D18)

I have it returning true now but want it to return number or false if not
equal

Thank you for the help.

Donna

Conditional Formula
 

Thank you for the feedback!

"Donna" wrote:

Thank you that worked perfectly and it makes sense.

"Sean Timmons" wrote:

=IF(SUM(E16*7.75%)=SUM(B18:D18),SUM(B18:D18),"FALS E")

"Donna" wrote:

I am pretty new to formula so help please. I want to condition a formula to
add down a column then add across a row and if = return the number otherwise
false.

=SUM(E16*7.75%)=SUM(B18:D18)

I have it returning true now but want it to return number or false if not
equal

Thank you for the help.

Donna