stating

Hi, I am trying to compare 2 values: D39 and F39. The second IF gives me a FALSE result. Why is it so? I tried also stating it as D39>F39 and D39< F39 but still got the same result. =IF(D39-F39>1;ROUNDDOWN(D39/F39;IF(D39-F39<1;ROUNDUP(D39/F39;0)))) Thank you for any help.

What I am trying to do is have cells that accept numerical values only. If an alpha value is entered I want a message to appear stating that only numeric values can be entered. Can someone please help me with this., Phil

Hey there, I'm trying to create a Calculated Measure using OLAP Tools for a pivot whose based is a tabular cube....excel 2016. here is my formula: CALCULATE([Measures].[Sales Revenue USD],DATESINPERIOD('Date'[Date], EOMONTH(LASTDATE( 'Date'[Date]),0),-3, Month)). i'm getting an error...

I am trying to set up a dynamic print area where the print area will always print A1:A20 and select 7 columns to the right to print from A1. The issue is that I am hiding columns once the day is done and everything I have looked at using offset etc is stating that I have to name cell references...

Hello Everyone, I am using excel table for mail merge, everything was working fine untill once i got the error stating "External table is not in the expected format". And now everything is mess. Kindly help me in this matter. Thanks.

A2 = 0.9464 B2 = 0.9 OR A2 = 0.14785 B2 = 0.1 How does one write a VBA code stating that if A2 is within .1 of B2, then TRUE, else FALSE? Thanks folks! =AND(A2<=B2+0.1,A2>=B2-0.1) The above code continues to give me :#VALUE! and it's irritating me to no end. I've cleaned, trimmed...