Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel ? formula

Copper Contributor

=IF(C37=0,C35*0.06,C38*0.14)

Should I not come up with a value if there is a # in C35?

 

1 Reply

@khristen250 

The formula should always return a number, unless C37, C35 or C38 contains text or an error.