ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with Formula (https://www.excelbanter.com/excel-worksheet-functions/99852-help-formula.html)

martins

Help with Formula
 

I have the formula =if(A1<10,"0",A3-A4) however, what would the formula
look like if I wanted to add in a comparison to calculate the result
where cell
A4 is 0 - is this an and/or scenario?

Please help


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=562380



All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com