Excel If condition

Occasional Contributor

The question is In H7, Calculate the Insurance amount IF the Condition is ONLY Excellent.
But when I apply the condition it gives me an error. kindly solve it.

2 Replies

@RanaNaimat 

=IF([@Condition]="Excellent",[@[Appraised Value]],"")

 

Is this what you are looking for?

@RanaNaimat Try this:

=IF([@Condition]="Excellent",[@[Appraised Value]]*Insurance,0)