Writing an IF statement in Excel -


  • i have inserted check box (form control) title "wall".
  • next have cell stating "false" if unticked , "true" if ticked.
  • next 2 cells dimensions of wall "length", "height". - lastly cell containing "area of wall".

i want write if statement in "area of wall" cell when check box ticked, area of wall printed, , if not ticked prints n/a if have written:

 =if((c2="true"), (d2*e2), ("n/a")) 

all happens cell reads n/a, no matter whether box ticked or not. please on how correct this? example

true should not in quotes, it's treating string when it's boolean. removing quotes should work or writing true()

the final formula should this:

=if((c2=true), (d2*e2), ("n/a")) 

Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -