Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formula | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formula | Excel Worksheet Functions |