close

=IF(iserror(B5 1gt;$B$3 $B$2,quot;quot;,B5 1),quot;quot;,(B5 1gt;$B$3 $B$2,quot;quot;,B5 1))

Excel keeps saying there is a problem with the first double quotes...

Help please?

What exactly are you trying to do?

ISERROR() takes one argument. IF() takes three.

As a wild guess:

=IF(ISERROR(B5 1gt;$B$3 $B$2), quot;quot;, B5 1)
In article gt;,
quot;Bradquot; gt; wrote:

gt; =IF(iserror(B5 1gt;$B$3 $B$2,quot;quot;,B5 1),quot;quot;,(B5 1gt;$B$3 $B$2,quot;quot;,B5 1))
gt;
gt; Excel keeps saying there is a problem with the first double quotes...
gt;
gt; Help please?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()