=if statement

[bluegold]

How do I add an IF statement to the following formula's so that if Column N, O & P have no information entered in Column Q, it returns "nd" (No Data).


<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Arial,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>N</td> <td>O</td> <td>P</td> <td>Q</td> <td>R</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">528</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.80</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-size: 9pt;">113</td> <td style="text-align: left; font-size: 9pt;">103</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">529</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.15</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-size: 9pt;">112</td> <td style="text-align: left; font-size: 9pt;">122</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">530</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left; font-size: 9pt;">draw</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">531</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left; font-size: 9pt;">draw</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); background-color: rgb(255, 252, 249); font-family: Arial; color: rgb(0, 0, 0); font-size: 10pt;"> <tbody> <tr> <td>Spreadsheet Formulas</td></tr> <tr> <td> <table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>N528</td> <td>=IF(P528=-1,F528 * 1, IF(P528=0,Z528+1,""))</td></tr> <tr> <td>O528</td> <td>=IF(P528=1,E528 * 1, IF(P528=0,Z528+1,""))</td></tr> <tr> <td>P528</td> <td>=SIGN(Q528-R528)</td></tr> <tr> <td>N529</td> <td>=IF(P529=-1,F529 * 1, IF(P529=0,Z529+1,""))</td></tr> <tr> <td>O529</td> <td>=IF(P529=1,E529 * 1, IF(P529=0,Z529+1,""))</td></tr> <tr> <td>P529</td> <td>=SIGN(Q529-R529)</td></tr> <tr> <td>N530</td> <td>=IF(P530=-1,F530 * 1, IF(P530=0,Z530+1,""))</td></tr> <tr> <td>O530</td> <td>=IF(P530=1,E530 * 1, IF(P530=0,Z530+1,""))</td></tr> <tr> <td>P530</td> <td>=SIGN(Q530-R530)</td></tr> <tr> <td>N531</td> <td>=IF(P531=-1,F531 * 1, IF(P531=0,Z531+1,""))</td></tr> <tr> <td>O531</td> <td>=IF(P531=1,E531 * 1, IF(P531=0,Z531+1,""))</td></tr> <tr> <td>P531</td> <td>=SIGN(Q531-R531)</td></tr></tbody></table></td></tr></tbody></table>

 

[jim may]

Into which column should the requested formula be entered?
Do you want to test for any blank cells in Columns N, O and P?

 

[bluegold]

Yes I want to test for blank cells for columns N, O and P. If blank it returns "nd".

 

[jim may]

Not completely sure I got the facts, but how about...

Excel Workbook
	N	O	P	Q	R	S
1		$1.80	won	113	103	nd
2	$2.15		loss	112	122	nd
3	$1.00	$1.00	draw
4	$1.00	$1.00	draw
Sheet1

Excel 2007

Cell Formulas
Range	Formula
S1	=IF(OR(N1="",O1="",P1=""),"nd","")

 

[bluegold]

It should display "nd" in the columns N - P when no data is entered into column Q.

 

[jim may]

Maybe this is what you want/need (?*(&%^%)

In Cell N528:

=IF(P528=-1,F528 * 1, IF(P528=0,Z528+1,""),IF(Q528="","nd")))