Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick little question
What would be the best way to combine the following two formulas?
=IF($A$25=0,"",$A$25) and =IF(AND($C$51=$C$53,$C$51<$C$52),5,0) Meaning if cell A25 is blank then leave a blank in this cell, but if there is a value in A25 then perform the following formula. Thanks in advance for the help......Ben |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick little question
=IF($A$25=0,"",IF(AND($C$51=$C$53,$C$51<$C$52),5, 0))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "ben simpson" wrote in message ... What would be the best way to combine the following two formulas? =IF($A$25=0,"",$A$25) and =IF(AND($C$51=$C$53,$C$51<$C$52),5,0) Meaning if cell A25 is blank then leave a blank in this cell, but if there is a value in A25 then perform the following formula. Thanks in advance for the help......Ben |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick little question
Just drop out the $A$25 you don't want and put the closing bracket at the end =IF($A$25=0,"",IF(AND($C$51=$C$53,$C$51<$C$52),5, 0)) -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531882 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick little question
try this
IF(A251,IF(AND($C$51=$C$53,$C$51<$C$52),5,0),A25 ) "ben simpson" wrote: What would be the best way to combine the following two formulas? =IF($A$25=0,"",$A$25) and =IF(AND($C$51=$C$53,$C$51<$C$52),5,0) Meaning if cell A25 is blank then leave a blank in this cell, but if there is a value in A25 then perform the following formula. Thanks in advance for the help......Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Macro question - How to delete two rows then skip one - and repeat | Excel Discussion (Misc queries) | |||
Quick Question | Excel Worksheet Functions | |||
quick charting question for similar charts on multiple sheets | Charts and Charting in Excel | |||
Excel Colours - Quick Question | Excel Discussion (Misc queries) | |||
Quick formula question | Excel Worksheet Functions |