G
Gambit-6
Hi was wondering if anybody would know how to use an IF formula in Infopath.
The formula in Excel that I am trying to get to work is:
=IF(C3="yes",D3,IF(C3="unsafe",D4,0))
In Infopath
C3 relates to Field 1
D3 = 0
D4 = -1000
However whereas Excel will give me the opportunity to hide the "extra bits"
i.e. the cell references rather than the numbers required, i'm not sure i can
do that in Infopath.
And just for info i can't write code to save my life!
The formula in Excel that I am trying to get to work is:
=IF(C3="yes",D3,IF(C3="unsafe",D4,0))
In Infopath
C3 relates to Field 1
D3 = 0
D4 = -1000
However whereas Excel will give me the opportunity to hide the "extra bits"
i.e. the cell references rather than the numbers required, i'm not sure i can
do that in Infopath.
And just for info i can't write code to save my life!