Need help for alert

M

mailmayank87

New Member
Joined
Jun 28, 2017
Messages
6
Hi All

I need help in excel i need alert written in front of number which includes same numbers like 555.50

2345.50

I need alert that this number contain 5.50,similarly if number is

2777.70 , i need alert that this number contain 7.70.

Thanks is advance.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
You must log in or register to reply here.

Similar threads

C
  • Question Question
One-off conditional formatting duplicate exeptions
Replies
1
Views
441
Artik
Artik
C
  • Solved
What is the difference between [INPUT MESSAGE] and [ERROR ALERT] in data validation?
Replies
1
Views
519
6StringJazzer
6StringJazzer
N
  • Question Question
Automated Deadline Alert and Progress tracking formulas?
Replies
3
Views
264
felixstraube
F
O
  • Solved
VBA Code to Find Duplicate Values in a Range and Add a Number at the End
2
Replies
12
Views
664
OilEconomist
O
zakasnak
  • Question Question
Check if a cell content has a match in a folder and if yes add a designator to corresponding cell
Replies
1
Views
241
eiloken
E

Forum statistics

Threads
1,223,901
Messages
6,175,277
Members
452,629
Latest member
SahilPolekar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top