If statment to not allow 2 fields to be filled at the same time

[ademello]

I have a form that i want to be filled out this is how part of it looks

Bid Bond (% or $) _______% $________ YES NO

and there is a seperate tab with an form that allows one party to enter a value for either the % or the $....so i want the person to be able to enter the % or the $ and if the value is correct it will output the YES and if its wrong it will output NO, my problem is how to make it output NO if both are filled in at the same time.

 

[tusharm]

What have you got so far in terms of validating the inputs?

 

[ademello]

=IF(OR(B26='Architect Input'!B11,C26='Architect Input'!B13),"Yes"," ")
thats for the yes field

=IF(AND(B26=0,C26='Architect Input'!B13,B26='Architect Input'!B11,C26=0),"No","")
thats for the no field

all the values are 0 and its outputting Yes and No

 

[tusharm]

The no formula
=IF(OR(AND(B26<>"",C26<>""),AND(B26="",C26=""),NOT(IF(B26=0,C26='Architect Input'!B13,B26='Architect Input'!B11))),"No","")

The yes formula
=IF(E26="No","",IF(IF(B26=0,C26='Architect Input'!B13,B26='Architect Input'!B11),"Yes",""))

 

[ademello]

Thank you so much, the No formula works perfect but no matter what numbers i input into the other fields the Yes never comes up.

Is there anyway i can send u my sheet?

thanks again.

 

[tusharm]

The no formula goes into cell E26. If it doesn't, you have to adjust the yes formula to correctly refer to the cell with the no formula. Adjust the reference to E26.